Forum Discussion

Poovarasan's avatar
Poovarasan
Frequent Visitor
5 years ago

DAX Many to Many

I have a two tables with Many-To-Many relationship, Here's the screenshot for two tables

Table1:

Table2:

I need to create measure like this 
Sum of rate = Sumx(Table1,IF(Table1'Year&month'>=Table2'Year&Month',Table1'Rate',0)

I have tried to use RELATED function here but not helping for this senario

Power BI Dax

10 Replies

    • Poovarasan's avatar
      Poovarasan
      Frequent Visitor
      5 years ago

      Hi, NidhiBhusari  

      Yeah, I tried but both table ID column has duplicate value when i try to change it Power BI will not accept Many-To-One relationship

       

      Thanks 

      Poovarasan

      • NidhiBhusari's avatar
        NidhiBhusari
        Icon for Helper IV rankHelper IV
        5 years ago

        Poovarasan Try to create a bridging table between two tables and then set relationship many - to - one.
        or can you share sample file? Let me try once