Forum Discussion
Solved
Max / Last date on a filtered range
Hi All, Hopefully an easy question. I have a data set where the value of a period is stored every subsequent period, where the period value is the same but the 'as at period' is monthly. The ...
I solved my issue.
I created a calculated column which concatenated the elements which would impact my filter, then using that column as a variable I filtered my table using MAXX on the As At date.So far the numbers reconcile.
I solved my issue.
I created a calculated column which concatenated the elements which would impact my filter, then using that column as a variable I filtered my table using MAXX on the As At date.
So far the numbers reconcile.