Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |