Forum Discussion

Nourhassan's avatar
Nourhassan
Icon for Helper I rankHelper I
4 years ago

Calculate Change by previous row value

Hello,   I need to calculate the load change hourly, so how the load is changed from time to time per percentage like the table below.    I have a table with a TIME (From 0 to 23) Column an...
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

My proposed solution is based on the sample data you provided.  If the sample data does not cover the issue fully then please provide more descriptive sample data.

Nourhassan's avatar
Nourhassan
Icon for Helper I rankHelper I
4 years ago

Unfortunately, I don't have permission to upload the .pbix file here. 

Kindly find below a table with more data. 

 

R_DATER_TIMELOAD
12/01/20210795
12/01/20211724
12/01/20212697
12/01/20213677
12/01/20214667
12/01/20215658
12/01/20216734
12/01/20217692
12/01/20218707
12/01/20219728
12/01/202110756
12/01/202111766
12/01/202112764
12/01/202113730
12/01/202114725
12/01/202115780
12/01/202116779
12/01/202117781
12/01/202118881
12/01/202119860
12/01/202120838
12/01/202121837
12/01/202122837
12/01/202123811

 

The problem only occurs when the date column is added. I think the problem is that it is the same day in each row.

 

 

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Your sample data is not fully covering your issue.  Provide at least two days'  worth of hourly snapshots.

    • Nourhassan's avatar
      Nourhassan
      Icon for Helper I rankHelper I
      4 years ago

      The issue is that I only have the data for one day and the idea is to calculate the change in hours for one day. 

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        4 years ago

        Please explain why you need to add the date column in that scenario.