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

I think you have made a mistake with the number to divide. The dividend should be the first number of Subtraction (Minuend).

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

Also, when I put this measure in my table, then I got an empty column without error. 

Can someone help me please? I don't know why the column is blank

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