Forum Discussion

Bakhtawar's avatar
Bakhtawar
Icon for Post Patron rankPost Patron
7 years ago

Difference between 2 columns in power bi

I am trying to take the difference between two columns. Below is an expression in qlik sense that I would like to translate into DAX   LPO_DATE - (CLM_INTM_DT) +1 I tried this in power bi DAX but...
Need Help
Bakhtawar's avatar
Bakhtawar
Icon for Post Patron rankPost Patron
7 years ago

relationship already developed.. have you checked the link ?

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
7 years ago

If have seen it so there is an Warning while creating a Many-to-Many relarionship. So make the key values unique and atleast single match in both the key column.

(See below screen shot of your file)

 

  • Bakhtawar's avatar
    Bakhtawar
    Icon for Post Patron rankPost Patron
    7 years ago

    yes i know and this is the only key which should be link .. if i get any other realtionship then same error occured.. 

    • Tahreem24's avatar
      Tahreem24
      Icon for Super User rankSuper User
      7 years ago

      Error occured due to below reason most probably:

      1) Check whether the boht the key column dont have any null values.

      2) Alteast one common value should be present in both the key column.

       

       

       

      • Tahreem24's avatar
        Tahreem24
        Icon for Super User rankSuper User
        7 years ago

        From your data it is clearly shows that there NULL entry in key column (LPO_Key) in LPO_Excel table(Refer screen shot below) . So clear out this null values and then create one-to-many relation.