cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michaelag Frequent Visitor
Frequent Visitor

working out MTD figures

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: working out MTD figures

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
1 REPLY 1
Super User
Super User

Re: working out MTD figures

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 45 members 1,215 guests
Please welcome our newest community members: