Trying to connect two tables to date dim table and connect them to each other with M2M

[NitzanMat]

Hey guys,

[Fowmy]

@NitzanMat 

It will create an ambiguity when you try to connect Demand and Supply tables. This should be handled using one-to-many realtion to Date table from these two tables. you can handle the calculation using various functions in DAX.

Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.