Forum Discussion
Calculation Group - Conditional Colour Formatting - Conflict Color Rule
Dear, Community I have some problem about condition format after i use calculation group as detail below, On hightlight that is conflict color that I setting in rule. Here is rule I s...
This is I expected as detail below,
This column builded by individual measure.
SumMTD = CALCULATE([SumActAFC],DATESMTD(DCalendar[Date]))
SumMTD Previous = CALCULATE([SumMTD],DATEADD(DCalendar[Date],-1,MONTH))
%IncreaseMTD = IFERROR(([SumMTD]-[SumMTD Previous])/ABS([SumMTD Previous]),SIGN([SumMTD]))
% Change Month to Date = CALCULATE([%IncreaseMTD],ALLSELECTED(DCalendar[Year&Month2])) << for rule condition formating