I have matrix that look like this:
I want to easily identify the biggest variations between the end of each month (if you have any tips on best visuals for this case, it'd be plus).
I want to build a matrix like this:
Showing the variations from the past period to the next one.
Go to Solution.
You can create a measure to compare with endofmonth and end of previous month.
ENDOFMONTH function (DAX) - DAX | Microsoft Docs
Paul Zheng _ Community Support TeamIf this post helps, please Accept it as the solution to help the other members find it more quickly.
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.