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.
I have a fairly small table
On each row is a different date, e.g. [4/1/2015, 5/1/2015, 6/1/2015]
On each of these rows there is a value, lets say, [7, 8, 15] respectively for above
I want to find the change per month as a column e.g.
ChangeFromPreviousMonth = [ n/a, 1, 7 ]
n/a because there was no data point before 7 in the above example
Any thoughts on how to achieve this would be greatly appreciated! Thanks!
Solved! Go to Solution.
Take a look at the PREVIOUSMONTH function:
You can also check out the Time Patterns here:
http://www.daxpatterns.com/time-patterns/
Take a look at the PREVIOUSMONTH function:
You can also check out the Time Patterns here:
http://www.daxpatterns.com/time-patterns/
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |