YTD,MTD,15 Days Sales calculation based on date selection on slicer

[Anonymous]

Hi All,

       I  need YTD,MTD, 15 Days sales calculation in a table based upon date selection slicer. how to calculate MTD, YTD sales based on date selected in a slicer.

Thanks,

Varsri

[v-yuta-msft · Accepted solution]

@Anonymous ,

You just need to create a measure using DAX function TOTALMTD and TOTALYTD like pattern below:, then result will be filtered by the slicer.

Result =
TOTALYTD (
    SUM ( InternetSales_USD[SalesAmount_USD] ),
    DateTime[DateKey],
    ALLSELECTED ( InternetSales_USD )
)

Result =
TOTALMTD (
    SUM ( InternetSales_USD[SalesAmount_USD] ),
    DateTime[DateKey],
    ALLSELECTED ( InternetSales_USD )
)

Community Support Team _ Jimmy Tao

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