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?
Anybody have any thoughts for TLK?
Ed Price, SQL Server Customer Program Manager (Blog,
Answer an interesting question?
Create a wiki article about it!
Is this still an issue?
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?