I have a a table where i need a new column made based on info on one of the other columns.
The table looks like this
|1||C||Next week delivery|
Return to sender
I want to create a new column that duplicates the Description of a Order No. where the Type is C to the rest of the rows of that Order. So in the end it should look like this:
|Order No.||Type||Description||New column|
|1||A||(blank)||Next week delivery|
|1||B||(blank)||Next week delivery|
|1||C||Next week delivery||Next week delivery|
|2||A||(blank)||Return to sender|
|2||B||Check bounced||Return to sender|
|2||C||Return to sender||Return to sender|
I achieved this already with a simple LOOKUPVALUE measure:
LOOKUPVALUE(Table[Description], Table[Type], "C", Table[Order No.], SELECTEDVALUE(Table[Order No.]))
But the calculation is too heavy for the amount of rows i have. That's why i want it done as a calculated column so the heavy lifting is done when the user opens the report.