Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Dax calculation - MTD as of yesterday

I need to have a calculation that will sum up a measure and give me the MTD value, but I need MTD to be as of yesterday, not today. My concern is for the first of the month. If it's November 1st, I need to have this show SUM(Amount) from Oct 1-31, then on Nov 2 it will show SUM(Amount) from Nov 1 only.

Super User
Super User

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.