Forum Discussion
Time Intelligence Quick Measures Problem
Hi Belinskaya00 ,
You will need a Calendar Table.
Check this link to create a Calendar Table
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
You can then create 2 measure .
Total Sales = SUM(Table[Sales])
Sales MTD = CALCULATE( [Total Sales], DATESMTD( Dates[Date] ) )Also suggest you see this video
Regards,Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!
Hi Belinskaya00 ,
You will need a Calendar Table.
Check this link to create a Calendar Table
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
You can then create 2 measure .
Total Sales = SUM(Table[Sales])
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hello! Thank you, i think it helped:)
