cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
michaelag Visitor
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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 209 members 2,027 guests
Please welcome our newest community members: