Forum Discussion
onedayover
Helper III
Helper IIIMatrix for month over month data and the changes
I'm trying to create a this matrix from a table that contains the current month, previous month and the change in value and percentage. My current data table looks like this... YearMonth MonthN...
I would recommend you lose the "Current Month" and "Previous Month" columns - you don't want to box yourself in with that. Either use measures to figure out the max month, or use a slicer.
See attached for a sample implementation.
onedayoverHelper III
Helper IIIThank you lbendlin, I appreciate your advice re current/previous months. This is exactly what I needed and it's very much appreciated 🙂