Previous Data display Today -1 MTD

[Anonymous]

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

[Anonymous]

Hi @Anonymous ,

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]

Hi @Anonymous 

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%20the%20visualization%20in%20future%20dates,-Most%20of%20the 

Did I answer your question? Kudos appreciated / accept solutio