MTD Total

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Hi Stelian ,

Please have a try.

For the current year MTD (up to the previous day):

MTD CY =
CALCULATE(
SUM('Actual Sales'[SoldAmount]),
DATESBETWEEN(
DeliveryNoteDateDim[DeliveryNote Date],
STARTOFMONTH(DeliveryNoteDateDim[DeliveryNote Date]),
PREVIOUSDAY(MAX(DeliveryNoteDateDim[DeliveryNote Date]))
)
)

For the last year MTD (up to the previous day of the same month):

MTD LY =
CALCULATE(
SUM('Actual Sales'[SoldAmount]),
DATESBETWEEN(
DeliveryNoteDateDim[DeliveryNote Date],
STARTOFMONTH(SAMEPERIODLASTYEAR(DeliveryNoteDateDim[DeliveryNote Date])),
PREVIOUSDAY(ENDOFMONTH(SAMEPERIODLASTYEAR(DeliveryNoteDateDim[DeliveryNote Date])))
)
)

In these measures, the function is used to specify the range of dates for the MTD calculation. The function helps to exclude the current day's sales from the total, ensuring that the calculation is up to the previous day.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for your answer, I've tried your PY formula but it show me the cumulated total to each date (I have days on rows). I need the MTD PY for each day and in Total field the MTD PY for previous day which is the last day with values.