I’m putting together some Dashboards to compare vehicle movements before and after lockdown for various parts of the world.
I have a lock down date of March 27th for Sth Africa. I’d like to setup a slicer for a Dashboard for before and after. Ideally to look at trends before and after most likely on a percentage basis.
Would this be best done as an additional column in the main Date Table and if so what how would I setup the M Code. Or should I do this using DAX instead with grouping.
How would I be able to set this up for various countries with various lockdowns dates also.
Ideally it would be good to have all the lockdown dates line up as the starting date.
Thanks in advance for any help you can provide.