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])
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
Yes, it is a generic formula that works for any month. If you post a sample workbook with some loaded realistic data including a calendar table, I will show you.
This doesnt work. The whole table colors will be changed based on last month data
