Forum Discussion
Solved
Create Gannt Chart data from tasks
Hi all I am trying to create data most likely very similar to gannt chart data Here below is an example of my data. I have task 1 & 2 and in each line(task) I have a few columns with details ab...
Hi hlynurgudna ,
Like this?
create the following measure:
Measure 2 = VAR _S = SELECTEDVALUE('Table'[index]) var _min = MINX(FILTER(ALLSELECTED('Table'),[Type]=MAX('Table'[Type])),[index]) var _max =MAXX(FILTER(ALLSELECTED('Table'),[Type]=MAX('Table'[Type])),[index]) return SWITCH(SELECTEDVALUE('Table'[Type]),"A",IF(_min = _S, 0.79,IF(_max = _S,0.67,1)),IF(_min = _S,0.17,IF(_max = _S,1,1)))You can also refer to my pbix file for better understanding
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi hlynurgudna ,
Like this?
create the following measure:
Measure 2 =
VAR _S = SELECTEDVALUE('Table'[index])
var _min = MINX(FILTER(ALLSELECTED('Table'),[Type]=MAX('Table'[Type])),[index])
var _max =MAXX(FILTER(ALLSELECTED('Table'),[Type]=MAX('Table'[Type])),[index])
return
SWITCH(SELECTEDVALUE('Table'[Type]),"A",IF(_min = _S, 0.79,IF(_max = _S,0.67,1)),IF(_min = _S,0.17,IF(_max = _S,1,1)))
You can also refer to my pbix file for better understanding
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly