Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Folks,
Just I am marking MTD, MTD Last Year and others in Calendar table , using below DAX and getting correct result but in Last Year MTD calculations giving me full month .
For example like Today 7th 2021 so MTD would be 1-7th Feb of 2021
but for Last Year MTD - It should 1-7th Feb2020
Current_Month_LYSM = SWITCH(Dates[Month_Diff],0,"CM",1,"LM",12,"LYSM","Other Months")
I dont have to use any measure like TotalMTD(sum(sales))) like this.
I have to idicate based on Dates.
Thanks
That is by design. You need to add a column in your Dates table that flags all the days that are one year older or more than today (or one month older etc depending on what you compare), and then you need to add that flag as a filter in the calculation
Something like
Previous Year To Date =
calculate(something something, SAMEPERIODLASTYEAR(sales[date]),dates[isinpreviouspast]=TRUE())
Note that I said column, so this assumes that you are refreshing your dataset daily.
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |