Row - The previous row

[F2Di]

I need to get the value now- the value in the previous row

- an exepression in power bi report builder 

Thanks

[DataVitalizer]

Hi @F2Di 

In PBRB you can return the previous value using the Previous function, here is a link to its description

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-prev...

Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

[Ashish_Mathur]

Hi,

I am not sure about Power Builder but i can try to do so in DAX as a calculated column.  Share some data and show the expected result.

[F2Di]

and i needed to be like this 

[Ashish_Mathur]

Hi,

I do not know anything about Power builder.  So do you want this to be done in PowerBI Desktop with a calculated column or with the Query Editor?  Also, share data in a format that can be pasted in an MS Excel file. 

[F2Di]

Query Editor, i need just an expression can be used

[Ashish_Mathur]

Share data in a format that can be pasted in an MS Excel file. 

[F2Di]

i solved the problem with this exepression 

but there is another problem with the first row