Forum Discussion

PSB's avatar
PSB
Icon for Helper III rankHelper III
2 years ago
Solved

Power Query to calculate values based on previous 7 days values

I need Power Query to generate value in formula coulumn by below formula. Each of the value is created with sum of previous 7 days values. Sample in table below.   Forumula column in Date 11/21 sh...
Need Help
  • PSB's avatar
    PSB
    2 years ago

    My ultimate goal is to achieve this formula. Do you suggest to add half of calculations to M1 and M2 or it can be added to Measure?

    =100*((SUM(E10:E16)+SUM(F10:F16)-SUM(G10:G16)-SUM(H10:H16))/(SUM(D10:D16)+SUM(E10:E16)+SUM(F10:F16)-SUM(G10:G16)-SUM(H10:H16)))

  • PSB's avatar
    PSB
    Icon for Helper III rankHelper III
    2 years ago

    My ultimate goal is to achieve this formula. Do you suggest to add half of calculations to M1 and M2 or it can be added to Measure?

    =100*((SUM(E10:E16)+SUM(F10:F16)-SUM(G10:G16)-SUM(H10:H16))/(SUM(D10:D16)+SUM(E10:E16)+SUM(F10:F16)-SUM(G10:G16)-SUM(H10:H16)))

    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      2 years ago

      where was it written that you want this is the formula, you didn’t write at the beginning

      and this formula is incomprehensible, how do I know what it is

      E10:E16

      G10:G16

      .....