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
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.