Obsidian | Level 7

## Post COVID counting

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
Rhodochrosite | Level 12

## Re: Post COVID counting

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