Compare the value with previous value to return the highest one

[Anonymous]

Hi,

Im having a bit struggling with DAX when trying to compare values for each rows. What I am trying to do is i want to return the higher value if I compare one by one row for energydata_value. For example, if the current value that I want to compare is 2253, it is lower than the previous 2467, thus, the max column will update that '2467' for that row. And if I meet the new maximum number, the max column will return that new max number.

This is the data that I am currently used. The max column is the expected result that will return the higher value if we compare with the previous value.

Is this possible in Power BI? If yes, I am very happy if anyone can help me with this. Thanks a lot!

[amitchandak · Accepted solution]

@Anonymous , a new column

maxx(filter(Table, [Date/time] <= earlier([Date/Time])), [Evergydata_value])