Forum Discussion
Solved
Calculating Percent Change
I have a table with 4 columns as shown below: I also created 2 calculated columns which a) gives me a 1 for the LatestDate in the dataset (April 2021) and then b) gives me a 1 for the LatestDa...
Hi natasha519
If I understand correctly, you only look at the MaxDate and MaxDateMinus1Year, then you want to put the values and percent change in the same matrix? Here is one way, file attached
I got the dummy data,
created a new table as the custom column
Thank you so much!! Do you mind explaining to me what you did so I can learn for my own self please?
Hi natasha519
I was creating a custom column for the Columns in Matrix, the use SWITCH to do different calculation (or call different measures) as you wanted to calculate different values in the same matrix...