Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Subtracting the value from previous value

In the Excel, I am using the formula =IF((D4-D5)=(C5-C4),"OK",((D4-D5)/(C5-C4))) to calculate the productivity for each week. However in Power BI I am unable to locate any such option to select individual cell. Can anyone please suggest how I can run this formula in BI please?

1st Coloumn= Date, 2nd - Orig Estimation, 3rd aka C - Completed Work, Coloumn 4 aka D is Remaining days

24 February 20201670.52017418.57652435.5
02 March 20201670.52122.75352.758052475.5
09 March 20201670.52222.25299.5851.252521.75
16 March 20201320.52082.25153914.752235.25

 

 

All I want a value subtraction from  299.5-153 and 914.25 -854.75 in a new coloumn. Any suggestion 

 

Also, is  there any way in which I can add information manually in the BI instead of adding CSV or excel file every week. My data only changes once in a week. However, I have to load entire CSV file every week to analysis.

 

Please suggest,

Show and Tell
Tutorial Requests
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    You could refer to my sample for details.

    Best Regards,
    Zoe Zhi

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

6 Replies

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi Anonymous , 

    If you want to get result of current row-previous row, you could refer to my sample for details. If not , please correct me and inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      https://1drv.ms/x/s!ApDgFRXBWrzSp313Wm95IfWWiRqw?e=20MDyz 

       

      Hi Zoe,

       

      I have attached the excel sheet. Basically I am looking for the formula in Column G, H and I. Any help would be much appreciated. At the time being we can overlook formula in column F. 

       

      The formula in column E named as 'Overspend' is easy. I reckon I would be able to do it. 

       

      Thank you again,

       

      Regards,

      Amit

      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi Anonymous , 

        You could refer to my sample for details.

        Best Regards,
        Zoe Zhi

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