cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sheetalr21 New Member
New Member

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.

 Demand.PNGProduct Demands

 

Supply.PNGSupply

 Output.PNGDesired 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

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Relative relation between two tables

@sheetalr21,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: Relative relation between two tables

@sheetalr21,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 172 members 2,311 guests
Please welcome our newest community members: