Assets & Liabilities calculation and Date Slicer select

    General discussion

  • Hello,

    What formula can be used for Assets&Liabilities and Date-slicer (YYYY/MM) calculation?

    The current formula for Assets&Liabilities is:

    MyCombinedMeasure:=IF(HASONEVALUE(Accounts[AccountType]); SWITCH(VALUES(Accounts[AccountType]); "PL"; [MeasurePL]; "BS"; [MeasureBS]))

    When I select the Slicer YYYY/DD range I need to use the Running Totals 'Assets&Liabilities' for the selected date-range.

    How to tide slicer selection and data when ALL conditions have been applied already?



    Friday, August 16, 2013 7:55 PM

All replies