Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need to display second row data into first row using DAX Expression

I am looking Next Date column value as per below table, I have three rows in table those are create using summarizedrows function. I am able to get previous value uisng Earlier fucntion but unable to...
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    I am not sure of where my suggestion will plug into your existing table function, but on a physical input table, this calculated column formula should get you your desired result

    =calculate(min(data[date]),filter(data,data[name]=earlier(data[name])&&data[date]>earlier(data[date])))

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks Ashish, Solution is working as expected

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

You are welcome.