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])
