MTD with variable date

[Anonymous]

Hi,

I would like some help with the following problem. I have a table with sales per day. I would like to calculate MTD sales, however I want the result to change based on a single day time slicer. I am using TOTALMTD function, however, when selecting a single day, the result is only the sales of that specific date, instead of the MTD sum.

For example:

Day	Sales
1/6	100
2/6	50
3/6	120
4/6	200

In the above example, when selecting 3/6 as date, the result would be 120, instead of 100+50+120.

Could you please help me with the above? Thank you in advance!

[Greg_Deckler]

 See if the approaches here help:

Also: To **bleep** With Time Intelligence - Microsoft Fabric Community

@Anonymous