Forum Discussion
Lookup column
Hi All, In order to identify new documents posted during a month, I want to compare values of these documents between two dates. In my Table i have : One column "Dates" -> Format (dd.mm.yy) One...
Hi CrisCros23 ,
The screenshot you provided is from Power BI Desktop. Do you want to use the DAX implementation in Power BI Desktop or the M implementation in Power Query?
I would recommend to add a column that contains the value from the previous row. Then you can write out your logic for the new column with references to the current row only.
If performance matters, you have to use this function to retrieve the value from the previous row:
Fast and easy way to reference previous or next rows in Power Query or Power BI – The BIccountant
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.