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.
I want to calculate the sum of MTD sales per day for the same period of last year, only until a specific day.
So for example, if the filter is year= 2019 and month= 2, I need the MTD sales for february 2018 until the 5th, calculated day by day:
MTDSales= VAR MyDay = 5 RETURN CALCULATE( TOTALMTD(SUM(Sales); Calendar[Date]); SAMEPERIODLASTYEAR(Calendar[Date]); //here I need another filter to stop on the 5th! )
Solved! Go to Solution.
Hey,
please have a look here:
https://www.daxpatterns.com/time-patterns/
I think that almost every time intelligence calculation is covered here.
Please be alos aware that sooner or later you have to decide how to treat the upcoming leapyear in 2020, but there are some considerations about the same timeframe if a leapyear has to be considered in one way or the other.
Regards,
Tom
Hey,
please have a look here:
https://www.daxpatterns.com/time-patterns/
I think that almost every time intelligence calculation is covered here.
Please be alos aware that sooner or later you have to decide how to treat the upcoming leapyear in 2020, but there are some considerations about the same timeframe if a leapyear has to be considered in one way or the other.
Regards,
Tom
Hey,
please provide a pbix that contains sampole data and represents your data model.
Upload the file to onedrive and share the link.
Regards,
Tom
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |