Forum Discussion
Highlight increase
Well, that depends on your data.
You need a calendar table https://exceleratorbi.com.au/power-pivot-calendar-tables/
and time intelligence calcs. https://exceleratorbi.com.au/dax-time-intelligence-beginners/
Typically
total = sum(table[column])
total last month = calculate([total],dateadd(calendar[date],-1,year)
chg = [total] - [total last month]
% chg = divide([chg],[total last month])
Yes it is possible, but you haven’t provided any detail. So, you need to
1. Write a measure for this month
2. Write a measure for last month
3. Write measures for chg and %chg vs last month
4. Apply conditional formatting on your result based on the % chg measure.
- Thanks for replying Matt, so what measure do I need to write for this month n last month?
Well, that depends on your data.
You need a calendar table https://exceleratorbi.com.au/power-pivot-calendar-tables/
and time intelligence calcs. https://exceleratorbi.com.au/dax-time-intelligence-beginners/
Typically
total = sum(table[column])
total last month = calculate([total],dateadd(calendar[date],-1,year)
chg = [total] - [total last month]
% chg = divide([chg],[total last month])
- Can I use the above formula for multiple months
