Forum Discussion
Solved
Calculation Groups - Difference measures
Hi, Could somebody please help me whether this is possible? I need the layout like below to be in a matrix. I've used a calculation group for current and previous period and this works well b...
output
link to file :
https://drive.google.com/file/d/1ZGTRZGdnUbNmPqFTGsyRbRJ6rv1aJgMq/view?usp=sharing
let me know if this works for you .
If this answers your question , mark it as the solution ā so can you can help other people in the community find it easily .
table using enter data manually .
this way you are creating the structure of your table how you want it to be .
and then you play with the measure and switch to change the calculation behavior base on the column you are in .
The best I've managed is to get both measures to display as blank in a matrix by using this in tabular editor
IF( SELECTEDMEASURENAME() in {"Cost1", "Cost2"}, BLANK(), SELECTEDMEASURE() - CALCULATE(SELECTEDMEASURE(), SAMEPERIODLASTYEAR(DimDate[DateFull])) )