Forum Discussion
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...
pls try this
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)))
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)))
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
.....