The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
NewMonth =
var index = YEAR([Ready Date])*12+MONTH([Ready Date])+[ForcastMonth]-2
return int(index/12)&"-"&FORMAT(MOD(index,12)+1,"00")
NewMonth =
var index = YEAR([Ready Date])*12+MONTH([Ready Date])+[ForcastMonth]-2
return int(index/12)&"-"&FORMAT(MOD(index,12)+1,"00")
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |