Forum Discussion
Custom column
Hi, so I have two columns depth from and depth to. I need to create a new column called Total depth that: - has the first row the same as in depth from (30 in this case) - the rest of rows are copi...
Hi Anonymous ,
Make sure that the values are in Don't Summarize form
Use this formula for Calculated Column
Total Depthm =
SWITCH(
TRUE(),
'Table'[stepNo] = 1 , 'Table'[Depth from m],
'Table'[stepNo] = 2, 'Table'[depth to m],
CALCULATE(MAX('Table'[depth to m]),FILTER('Table','Table'[stepNo] = EARLIER('Table'[stepNo]) - 1))
)
Also add a blank row will step no to have the last value shown.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Anonymous What if I wouldn't like to change the original data in Query. Can it be done via measure/column in report visualization?