Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
emrei
Helper I
Helper I

Help with sumif from multiple tables

‎05-31-2023 08:51 AM

I am trying to calculate the blue highlighted columns in PowerBI in order to get the two graphs. I have the table in sheet 2 available. I am building the relationship to be between PO Date and Date. I get an error saying my expression containts columns from multiple tables. My formula is calculate(sum('Table1' [% Total Cost]),'Table 1'[PO Date]<'Table2'[Date]

emrei_1-1685547668607.png

 

 

emrei_0-1685547595063.png

 

emrei_2-1685548274982.png

 

Thank you!

Labels:
Message 1 of 1
244 Views
0
0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All