sum of two two cells with following dates with IF other cells equals XXX

[Anonymous]

Im trying to learn Power BI and using COVID-19 data as my data source. So I have data of COVID-19 cases per day and per country.

I want to create a new column that sums one date and the previous day for a specific country using Power Query. I have never created anything with Power Q before so keep in mind I am a real beginner.

Basically i want the formula to do this.

• Cell 1 =number of cases day 1
• Cell 2 = Sum of number of cases from day 1 and day 2
• Cell 3 = Sum of number of cases from day 2 and day 3
• etc
• It should also consider the name of Country in another cell so it doesnt sum the cases for two different countries.

I figure that i need to use IF and SUM functions for this but im having a hard time to figure out the code. 

 

[tctrout]

Hello @Anonymous 

If I understand you need correctly I think you are better off doing Rolling DAX caclulation as opposed to attempt to do this within M Code.  

There are plenty of articles online regarding rolling sums in DAX, I think if you incorporate this with the What If Scenario features you will have the information you are seeking.

[Anonymous]

@tctrout Thank you! Ill give it a shot.

[dax · Accepted solution]

Hi @Anonymous , 

You could try to use measure like below to see whether it work or not.

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.