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.
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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.