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

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.

Reply
PPK2698
Helper II
Helper II

Previous Data display Today -1 MTD

Hi,

Please help

In my fact table, data has come in until yesterday. However, when I calculate the Month-to-Date (MTD) for the previous month, it includes data up to today. What I want is for my measure to display data from the Previous Month up to yesterday.

 

Ex - Today is 11th Oct 2023 but i want to show 1st Sep 2023 To 10th Sep 2023 in my measure.

 

Note - My date table connected to fact tables

2 REPLIES 2
v-binbinyu-msft
Community Support
Community Support

Hi @PPK2698 ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu

some_bih
Super User
Super User

Hi @PPK2698 

On link below check part creation of ShowValueForDates measure which allow you how to control dates to be visible in your scenario. On the link you can find other useful time intelligence calculation, as MTD (Month-to-date) or PMC (Previous month complete).

https://www.daxpatterns.com/standard-time-related-calculations/#:~:text=in%20Sales.-,Controlling%20t... 

 

Did I answer your question? Kudos appreciated / accept solutio





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors