Forum Discussion

Amir851's avatar
Amir851
Helper I
6 years ago
Solved

Display Current row value in another row in different column

Dear All,   I am a bit new to Dax, I have a requirement to display the current row value(Sum of Duration) in the next row of another column(Sum of Duration1).   Description is a column of Table ...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Amir851 ,

     

    You may remain your [Rank_Measure], try to create another Rank column, then create measure [Sum of Duration1] as follows:

     

    Column: Rank = RANKX(ALL(Table1),[Sum of Duration],,DESC, Dense)
 
Measure: Sum of Duration1 = CALCULATE(Table1[Sum of Duration]),FILTER(ALLSELECTED(Table1), Table1[Rank] =MAX(Table1[Rank])-1))

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

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

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Amir851 ,

 

You can create measure like DAX below.

 

Sum of Duration1 = CALCULATE(Table1[Sum of Duration]),FILTER(ALLSELECTED(Table1), Table1[Rank_Measure] =Table1[Rank_Measure]-1))

 

Or you may add Index column to original table in Query Editor.

 

 

 

 

 

Then create measure like DAX below.

 

Sum of Duration1 = CALCULATE(Table1[Sum of Duration]),FILTER(ALLSELECTED(Table1), Table1[Index] =MAX(Table1[Index])-1))

 

 

Best Regards,

Amy

 

Community Support Team _ Amy

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

Amir851's avatar
Amir851
Helper I
6 years ago

Dear v-xicai ,

 

Thank you for your response,

 

I have tried that Dax which you mentioned earlier itself but it was not working and it returned empty value, The issue is that I cannot create an index column in this situation because Rank_Measure is a measure and it has four slicer acting upon it.is there is any other way to do it.

 

Thanks

Amir