Forum Discussion

LagSpencer's avatar
LagSpencer
Microsoft Employee
4 years ago
Solved

How to Create a dynamic Matrix visual using a date column to Assign Months

I have the following data below 

 

I looking to create a matrix and dynamiclly assign forecast Month based on Support ready date

so for example Work Item 1230 forecast month 1 = july, forecast month 2 = Aug and so on

For Work Item 1456 Forcast month would =Sep

 

example on matrix trying to create

 

 

  • vapid128's avatar
    vapid128
    4 years ago

     

    NewMonth = 
var index = YEAR([Ready Date])*12+MONTH([Ready Date])+[ForcastMonth]-2
return int(index/12)&"-"&FORMAT(MOD(index,12)+1,"00")

1 Reply

  • vapid128's avatar
    vapid128
    Solution Specialist
    4 years ago

     

    NewMonth = 
var index = YEAR([Ready Date])*12+MONTH([Ready Date])+[ForcastMonth]-2
return int(index/12)&"-"&FORMAT(MOD(index,12)+1,"00")