Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
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.
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 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |