cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Calculated column Sumif with multiple criteria from multiple tables.

Hey guys,

 

I've been trying something but sadly I am nowhere near as experienced for what I am trying to achieve. I was hoping you experts could help. I've visualized my problem in Excel below to make it much easier to explain.

 

What I am trying to achieve in this example is to create a calculated column in my budget table (see yellow marked) that sums all of "price" (from another table) per projectnum, only if column "y/n" says "yes".

 

Is this doable in powerbi? If so, I hope someone can tell me!

Thanks as always!

 

image.png

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Re: Calculated column Sumif with multiple criteria from multiple tables.

Try this friend,

  1.  create relationship between Budget and spent with name.

  2. use the below dax to create cal column in budget table 

       

Revenue= CALCULATE(SUM(Spent[price]),Budget[y/n]="Yes")
 
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

http://powerbi.baskarbiconsultant.com/

View solution in original post

3 REPLIES 3
Highlighted
Resident Rockstar
Resident Rockstar

Re: Calculated column Sumif with multiple criteria from multiple tables.

Try this friend,

  1.  create relationship between Budget and spent with name.

  2. use the below dax to create cal column in budget table 

       

Revenue= CALCULATE(SUM(Spent[price]),Budget[y/n]="Yes")
 
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

http://powerbi.baskarbiconsultant.com/

View solution in original post

Highlighted
Super User IX
Super User IX

Re: Calculated column Sumif with multiple criteria from multiple tables.

Create a project table

project = summarize(Budget,budget[Name],Budget[Y/N])

 

Join both the tables to this table using the project name. Now use the project [Y/N] as a slicer.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @

Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper III
Helper III

Re: Calculated column Sumif with multiple criteria from multiple tables.

aaaah I am stupid. I didn't realize there was no relation between the tables, which is why my attempts didn't work

 

Works like a charm. Thanks 🙂

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors