working out MTD figures

[michaelag]

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

[TomMartens · Accepted 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