CODEWITHSUNDEEP
daxpowerqueryexcel-2016
Dudeguy
Dudeguy

Reputation: 1

Summing data from specific rows in power query

I made a mini query here to represent the issue I'm having. I'm trying to find a measure or function I can use in power query that will give me the sum of the sales amount but only for rows where "Product Use" says "Kitchen".

FYI I'm using Excel 2016

(https://i.sstatic.net/A2SZsH38.jpg)

I've been researching all day and cannot find anything even though this seems like a very simple thing.

Upvotes: 0

Views: 31

Answers (1)

Ryan
Ryan

Reputation: 2347

This is the sample data I used for test.

enter image description here

I think you need to do the calculation in powerpivot

Total: =
CALCULATE (
    SUM ( Table1[Sales Amount] ),
    FILTER ( Table1, [Product  Use] = "Kitchen" )
)

enter image description here

Upvotes: 0

Related Questions