Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sivarajan21
Helper V
Helper V

DAX to return a column that has multiple filter criteria and multiple tables

Hi Good Day,

 

I have a proper data set that involves three tables viz,

sivarajan21_0-1674113349200.png

 

1)DataInvoice

sivarajan21_6-1674114329610.png

 

2)Points

sivarajan21_8-1674114438862.png

 

3)Factor

 

sivarajan21_7-1674114406973.png

 

I need a visual that shows Date column from Datainvoice,units column from datainvoice table multiplied with value column from Factor table.  

But the above can happen with few filter criteria as below

1)Date column from Datainvoice should fall between Start and End date of factor table and then return corresponding Value

column

sivarajan21_2-1674113916010.png

 

2)while filtering the above we should make sure that DBName-point-id from datainvoice should match DBName-point-id of

points table which inturn looks for DBName-Utility in factor table and picks up the VALUE column

sivarajan21_3-1674114049196.png

This is how the relationship looks:

 

sivarajan21_5-1674114097166.png

I want the output to look like below in a visual

sivarajan21_0-1674116785022.png

 

File Portfolio performance 

Looking forware to your response

Thanks in advance

 

@amitchandak 

@Ashish_Mathur 

@Greg 

@FreemanZ 

@Greg_Deckler 

 

0 REPLIES 0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors