topic Re: Sumifs in power bi in DAX Commands and Tips

Sumifs in power bi

Julier2307 — Sun, 31 Mar 2024 04:28:27 GMT

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.

Re: Sumifs in power bi

Jihwan_Kim — Sun, 31 Mar 2024 05:02:29 GMT

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.

Re: Sumifs in power bi

Julier — Sun, 31 Mar 2024 08:15:30 GMT

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?

Re: Sumifs in power bi

Julier2307 — Sun, 31 Mar 2024 09:17:02 GMT

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.

Re: Sumifs in power bi

Jihwan_Kim — Sun, 31 Mar 2024 12:05:20 GMT

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.

Re: Sumifs in power bi

Julier2307 — Mon, 01 Apr 2024 06:20:28 GMT

Fantastic, that worked, thank you!