Create new table based referring to old table based on MTD

[raassd]

Hi Team,

I have table_A where it has few columns and a date column.

My requirment is I have to create a new table refering to date colum in Tabe_A where I should be able to see only values from MTD in my new table.

Thanks in advane !

[ribisht17 · Accepted solution]

@raassd 

Use similar approaach using Time function for MTD Solved: Create a new table from existing table (Using DAX ... - Microsoft Power BI Community

= CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), DATESMTD(DateTime[DateKey]))

Regards,

Ritesh