Forum Discussion
Iterate automatically trough columns (conditional formatting on matrix table)
Hi, This is the table created: I'm using the following measure to do conditional formatting: color = var _a=CALCULATE(SUM('Table'[Oct'23]),FILTER(ALL('Table'),'Table'[KPI Name]=MAX('Ta...
Hi ferk_23 ,
The following link can solve your problem; instead of using hard coded "month name" in your sum formula; you should use previous month total sum logic.
I hope it helps you