Post COVID counting

[Noel88]

In the post-COVID world a question that is regularly getting asked is what growth is occurring in numbers since (for all intents and purposes for work) March 2020.

What I need to be able to do in VA is create a table that has numbers at end of month February and calculate the difference between that and the latest month. We have a "month end" in the data set and I need to show all three items in a table - February numbers, latest month numbers and the calculated difference.

I've tried various combinations of setting up March by itself using filters and latest month as a calculated item and using Treat As to change to number and then rank but can't get this to work. I've tried in both a list table and a cross tab. 

Any help would be sorely appreciated.

		Always the latest month
Center	February	July	Growth
A	3100	4566	1466
B	2828	3772	944
C	2868	3944	1076
D	593	1259	666
E	1104	1242	138
Total	10493	14783	4290

[FredrikE]

Hi!
Maybe you can achieve this by createing three new measures, one for february, one for the latest month and one for the difference.
Depending on how your months are formatted you have to define your formula, but something like this:

Feb: IF dateFromMDY(month(datepart(now())),1,YEAR(datepart(now()))) = 01FEB2020 return VALUE ELSE missing
Curr: IF dateFromMDY(month(datepart(now())),1,YEAR(datepart(now()))) = DATEOFMONTH return VALUE ELSE missing
Growth: Curr - Feb

Might help you 🙂