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'm very new to Power Bi and I'm having to calculate some MTD figures for forecast...
I've created the Calendar table, I have a range of dates pulling the data but cannot get it to work, I'm after:
Budget MTD to calculate from (BudgetEOM/over working days in the month)*number of days already gone in this month
Any suggestions pls
Many thanks
Solved! Go to Solution.
Hey,
I recommend reading this article, almost everything related to date calculations is covered here: https://www.daxpatterns.com/time-patterns/
If you need more help, please be more specific by providing your data model (a screenshot of your data model). Also consider to create a pbix file with sample data but still able to represent your data model.
Regards,
Tom
Hey,
I recommend reading this article, almost everything related to date calculations is covered here: https://www.daxpatterns.com/time-patterns/
If you need more help, please be more specific by providing your data model (a screenshot of your data model). Also consider to create a pbix file with sample data but still able to represent your data model.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |