Forum Discussion
Solved
Creating a column based on another calculated column
Hi. I need to report on two metrics: the latest date in a table and one week prior to the latest date. I successfully created a Latest Date column as such... 1 Latest Date = 2 VAR LatestDat...
If this is another column in the same table, why not just use
Latest Date Week Ago = [Latest Date] - 7
Pat
Well, that was easy! Thanks so much!