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
Thanks! Im not understanding the 'newTable' that you created and the purpose of it?