@BrianJ -
Sorry to bug you but , i want to add one more criteria to this scenario, i.e as we have used today as the function which identifies current date and calculates the related metrics. So now what if , my data for today is always of previous day . Would the DAX calculation specified above handle this.
So what i mean on 10/01/2020. The dataset gets refreshed and it holds the data of 09/01/2020.
Would this cause an issue in the real time scenario when my system date changes post 12:00 am and report would display blank for 10/01/2020.
I mean on 1st Jan the report should show current month to be December and PM value as November. On 2nd Jan it will display 1st Jan as CM and December as Previous Month. With Today() function being included would that help.
In My case of calculated column what i have done is that while getting the date table from database applied a condition , so that my date table fetches all the dates < today - " where CalendarYearMonth >= 201906
and [FullDate2] < cast(getdate() as date)"
And then created the calculated columns based on the Max date in the date table and the calculation are specified in my previous post. This is done to handle the scenario specified above. So with Today() function used in ur measure how would you handle this.
Thanks in advance