Forum Discussion
Custom column from DAX formula
Hello,
I'd like to add a custom column that calculates a Lookup just like the DAX does. I haven't chosen to do this in DAX because I need to transform the data before it gets into its final table state.
Appreciate any kind of help.
Thank you
Anonymous
Give this custom Column a shot
=Text.Combine( let mystage=[CurrentStage] in Table.SelectRows(Score,each mystage>=[From] and mystage <= [To] )[Stage], ",")
2 Replies
Anonymous
Give this custom Column a shot
=Text.Combine( let mystage=[CurrentStage] in Table.SelectRows(Score,each mystage>=[From] and mystage <= [To] )[Stage], ",")
Zubair_Muhammad wrote:Anonymous
Give this custom Column a shot
=Text.Combine( let mystage=[CurrentStage] in Table.SelectRows(Score,each mystage>=[From] and mystage <= [To] )[Stage], ",")
That's absolutly fabulous! Thanks! It works!