Forum Discussion
Helper IIIConditional Formatting Calculation Groups
Hi watje255_ju
It would have worked but that isn't how you're supposed to create a calcuation item. An item would be something like
CALCULATE ( SELECTEDMEASURE (), SAMEPERIODLASTYEAR ( Dates[Date] ) )SELECTEDMEASURE stands for whatever measure that you'd want SAMEPERIODLASTYEAR to be applied to in the context of the calculation group. You can see in the first screenshot of my initital reply how your setup behaves. In one of his videos, the author actually discussed how to create a calculation item
Helper IIIThanks for your reply. Well copied on the above, the calculation group was a workaround to get the format i desired Having Sales, Budget, Var as per Page 1 screenshot in the PBIX file. This blog suggests that the conditional formatting should work on individual meaures/calculation items https://www.youtube.com/watch?v=MbxJ1oHHyTg ? Cheers
Super UserHi watje255_ju
It would have worked but that isn't how you're supposed to create a calcuation item. An item would be something like
CALCULATE ( SELECTEDMEASURE (), SAMEPERIODLASTYEAR ( Dates[Date] ) )
SELECTEDMEASURE stands for whatever measure that you'd want SAMEPERIODLASTYEAR to be applied to in the context of the calculation group. You can see in the first screenshot of my initital reply how your setup behaves. In one of his videos, the author actually discussed how to create a calculation item