Forum Discussion
Solved
Time intelligence - Month and Year Issue
Hi, New user so apologies for the ignorence. I am looking at using time intelligence to calculate Sales performance for Year on Year (total) & also Month vs Month. Problem is my sales d...
Hi, Matho101 ;
You could create a column as follow:
Column = MONTH ( [MONTH] & " 1" )The final output is shown below:
Or create a column :
date = DATE([YEAR], MONTH ( [MONTH] & " 1" ),1)The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Matho101 , Create a new date column using the DAX
Date = datevalue("01-"&[Month] & "-"&[Year] )
Join this with a date table(join with date not month) and use time intelligence
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
