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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Relative relation between two tables

i,

 

I have 2 sets of tables in my data set - one for Product demand and another for product supply. I would like an output that displays supply based on their availability dates against the demand dates.

 Product DemandsProduct Demands

 

SupplySupply

 Desired OutputDesired Output

Note - Batch 6 & 7 from the Product supply should not appear against any demand since the availability dates do not match.

 

Thanks

Sheetal

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@Anonymous,

Please create a table using dax below.

Table = CROSSJOIN('Product Demand','Product Supply')


Then create a column in the new table using DAX below.

Column = IF('Table'[Demand Dates]>='Table'[Supply Date],1,0)


Drag the column to visual level filter and set its value to 1.
Capture.PNG

Regards,
Lydia

View solution in original post

1 REPLY 1
Anonymous
Not applicable

@Anonymous,

Please create a table using dax below.

Table = CROSSJOIN('Product Demand','Product Supply')


Then create a column in the new table using DAX below.

Column = IF('Table'[Demand Dates]>='Table'[Supply Date],1,0)


Drag the column to visual level filter and set its value to 1.
Capture.PNG

Regards,
Lydia

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors