Convert cumulative data to non-comulative data

Assuming the time component of your DateTime values are not all zeros, you can use an expression like this to get your result in a measure.  Use the measure in a table visual with your DateTime column.  Let me know if you need the column version instead.

Actual Consumption =
VAR __thisvalue =
    MIN ( Table[EnergyConsumed] )
VAR __thisdatetime =
    MIN ( Table[DateTime] )
VAR __prevdatetime =
    CALCULATE (
        MAX ( Table[DateTime] ),
        ALL ( Table[DateTime] ),
        Table[DateTime] < __thisdatetime
    )
VAR __prevvalue =
    CALCULATE (
        MIN ( Table[EnergyConsumed] ),
        ALL ( Table[DateTime] ),
        Table[DateTime] = __prevdatetime
    )
RETURN
    __thisvalue - __prevvalue

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Hi,

This calculated column formula works

Column = Casting[Incoming 33kv]-LOOKUPVALUE(Casting[Incoming 33kv],Casting[DateTimeStamp],CALCULATE(MAX(Casting[DateTimeStamp]),FILTER(Casting,Casting[DateTimeStamp]<EARLIER(Casting[DateTimeStamp]))))

Hope this helps.

Regretably both set of codes in Power bi did not work. I have now enclosed the larger data in the link

https://www.dropbox.com/s/kvagdhivzvhzq1w/energy.pbix?dl=0