Forum Discussion

Anonymous

Not applicable

6 years ago

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...

Anonymous

Not applicable

6 years ago

Hi Anonymous ,

Create a 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]))

) )

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Anonymous
Not applicable
6 years ago
Hi Anonymous thanks!
There are, however, to issues with this column:
- md_to3 and md_to4 should be equal to Total Depthm4 and Total Depthm5 respectively
- md_to16 (9726,71) is not copied/added to the Total Depthm column.
- Anonymous
  Not applicable
  6 years ago
  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
    Not applicable
    6 years ago
    Anonymous What if I wouldn't like to change the original data in Query. Can it be done via measure/column in report visualization?

Related content