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