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 October 2021 Release!
Mark your calendars and join us for our next Power BI Dev Camp!