Forum Discussion

harrinho's avatar
harrinho
Helper III
8 years ago

If Statement for a simple condition

Hi,    I have a major headache with a statement I want to create and it is dead simple. However, PowerBI doesn't allo me to create it.   I have two tables which are joined together with a relatio...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI harrinho

 

Which table is on the 1 side (Table A or Table B), and which table is on the many side?

  • harrinho's avatar
    harrinho
    Helper III
    8 years ago

    Thanks for getting back Phil_Seamark. Table A is the many (Project ID, Product, Product Split %) and BU and Product is Table B. The two tables are joined on the Product name 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      harrinho,

      Does my DAX return your expected result?

      Regards,
      Lydia