Current MTD shows blank values

[Anonymous]

Hello, I have a problem with MTD column. I want on this column to show only April '22 sales and not the previous months. For example the sales for April '22 is 7379,42 so I want this number only to be shown on MTD column, of course I want the same for the other product types. Thank you.

[AilleryO]

Hi,

I would suggest to use DATESINPERIOD instead of MTD to get only one value, the one from previous month with something like :

Total Last Month = CALCULATE([Total Amount], //Calculate your measure...
DATESINPERIOD(Sales[Date invoice],//In a period of time
TODAY(),//starting from today
 -1,//and back one...
MONTH)) //month...

This should bring you only one value. Let us know

[Anonymous]

[Anonymous]

I have values for MTD but I want only the value of the latest month on the MTD column and also not change the information of the other columns.

[v-chenwuz-msft]

Hi @Anonymous ,

If possible, please share your pbix file without sensitive data and expect result.

Best Regards

Community Support Team _ chenwu zhu