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.
Note - Batch 6 & 7 from the Product supply should not appear against any demand since the availability dates do not match.
Go to Solution.
@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.Regards,Lydia
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!