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.

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

Anonymous I would highly recommend adding as a measure, the expression I shared can be used to add as a measure as well. You are absolutely right that on a larger dataset the solution provided by Ashish_Mathur  will be very slow.

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    parry2k , Created as a measure,Date column values are not coming as expected some are showing incorret values. Thanks for the sugesstions I will try  to check and correct mesaure logic to show correct results