DAX FORMULA MTD

[hueuro]

HI 

HOW CAN I GET DAX FORMULA FOR YTD &MTD FOR PERTICULAR MODEL

[Fowmy · Accepted solution]

@hueuro 

Create a date table and make the relationship to your fact table. You use the following DAX formula patterns for MTD and YTD.
To know the results by Model, Add the Model as slicer or in the matrix as the first item on the row.

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

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