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 everyone,
I'm hoping you can help me with a problem I'm having with my TotalMTD Dax.
Here is my formula for the measure:
Solved! Go to Solution.
Hi @738o51,
To use Time intelligence function, Continuous time is necessary for most time. you can try to generate a calendar table and using in your DAX.
Calendar = CALENDARAUTO()
MTD Total Surgeries = TOTALMTD(SUM(Surgery[Completed Surgeries]),'Calendar'[Date])
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @738o51 ,
Based on my test, Your formula works fine on my side, Could you please figure out what difference between my mockup data and yours?
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
https://www.dropbox.com/s/pdoi27zrvsq967d/TotalMTD-not-pulling-from-this-month%20v2.pbix?dl=0
Thanks for your help! You're correct that there is no error in the table. I added a service column in the pbix above and showed how the error manifests in a bar graph visual. While there were no orthopedic surgeries in August, you'll notice that the bar graph shows 1 (which matches the july number).
I think then the way to fix it may be to create a new column indicating when we are in the current month, and excluding any other data from the visual that way.
Thanks for helping me think through this!
Hi @738o51,
To use Time intelligence function, Continuous time is necessary for most time. you can try to generate a calendar table and using in your DAX.
Calendar = CALENDARAUTO()
MTD Total Surgeries = TOTALMTD(SUM(Surgery[Completed Surgeries]),'Calendar'[Date])
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This worked! I was using a date from the surgery table. After creating the calendar table and using that date instead, things seem to be working. Thank you!
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 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |