Sumifs in power bi

[Julier2307]

Hi, i have sales by date and I want to use Sumifs to calculate the number of sales between days 1and 7, then days 8 and 15, then days 16 and 22 then days 23 and 31, I have done this in excel but I am unable to do it in power bi. 

[Julier2307]

Fantastic, that worked, thank you!

[Julier2307]

I am trying to sum up the sales in between the days, the count works but I am unable to change this to sum, any help greatly appreciated.  

[Jihwan_Kim]

Hi, I am not sure how your semantic model looks like, but I tried to creae a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

[Julier]

Hi, i managed to get this to work but i cannot work out how to sum the number of sales rather than count the rows?

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

I am still using my sample, but if the semantic model in my sample is not similar to what you have in your sample, please share your sample pbix file's link.