Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Getting negative value, help

Hey!   I am trying to calculate the consumed energy, by calculating current energy minus previous (from TotalEnergy_MWh), since it is an accumulating number, with following formula (see data below)...
Need Help
v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

You can change the Rank in  DAX below.

 

Rank = RANKX(FILTER(Data, Data[Device] = EARLIER(Data[Device])), Data[TotalEnergy_MWh], ,ASC)

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi  Anonymous  ,

     

    Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.

     

    Best regards

    Amy Cai