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.
Hi, I am implementing a retail NRF 4-5-4 calendar as a date dimension for my report and I have modified the measures to fetch from the new calendar rather than the old one. The calendar starts on Feb 3rd 2019 and ends March 2nd 2019 ---> This period = month of February 2019. My MTD column is showing me blanks. There is no value.
DAX Measure:
Hi @Anonymous,
Based on my research, time intelligence functions lile TOTALMTD works based on natural calendar, not work for custom date dimension. Reference: DAX Time Intelligence Functions
Regards,
Yuliana Gu
Anyone have other solutions? My LY MTD and LY YTD is just providing me full month and full year sales rather than the MTD of this year - 1 year ago
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |