Forum Discussion

Anonymous's avatar
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...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

You may create a calculated table as below, modify the measure and use the columns from the table to display the result.

New Table = 
UNION(
    'Table',
    ROW("Step No",9,"Depth from",BLANK(),"Depth to",BLANK())
)

 

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

As mentioned by v-alq-msft . Create  a Calculated Table

 

Incase you want  measures instead of Calculated Column to five you the values.

 

Total Depthm Measure =
SWITCH(
TRUE(),
SELECTEDVALUE('Table'[stepNo]) = 1 , MAX('Table'[Depth from m]),
SELECTEDVALUE('Table'[stepNo]) = 2, MAX('Table'[depth to m]),
CALCULATE(MAX('Table'[depth to m]),FILTER(ALL('Table'),'Table'[stepNo] = MAX('Table'[stepNo]) - 1))
)
 
Regards,
Harsh Nathani
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous  the problem is that the number of steps can vary, this time it's 9 but it can be only 3 or 30 next time.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    One solution could be to  do it QueryEditor.    to create a Table with 1 row in Query Editor. Give that an index value 10000000. And then append this table to the Steps table.   This will automate and you will not need to worry till your index in Steps Table reaches 10000000.  

    For more info I will need to see your data set.  

     

    Regards,

    Harsh Nathani