Forum Discussion

Matho101's avatar
Matho101
New Member
4 years ago
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...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Matho101 ,

 

Try this:-

Date = 
var _month = SWITCH([month],"Jan",1,
"Feb",2,
"Mar",3,
"Apr",4,
"May",5,
"Jun",6,
"Jul",7,
"Aug",8,
"Sep",9,
"Oct",10,
"Nov",11,
"Dec",12)
return DATE([Year],_month,1)

 

Output:-

 

Thanks,

Samarth