Forum Discussion

harrinho's avatar
harrinho
Icon for Helper III rankHelper III
8 years ago

Relationship error

Hi everyone. I'm trying to create the following relationship but I really can't figure out where the error comes from. Here is the other calculation that the circular dependency refers to:  but aga...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

You should not look up the month_name column from the other dataset.  In the CDL_Project_Forecast table, use this formula to extract the month

 

=FORMAT(CDL_Project_Forecast[full_date],"mmmm")

 

Now you will be able to create the relationship.

  • harrinho's avatar
    harrinho
    Icon for Helper III rankHelper III
    8 years ago

    thank you guys for your replies. Ashish_Mathur do you mean to create a new measure or column with this calculation or to replace an existing one?

     

    Because I already have this calculated column in place

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi,

       

      Create a new calculated column.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi,

       

      If you already have a Month column in the CDL_Forecast_Project Table, then why do you have an other Month Name column (in the image you have posted in the first post)?

      • harrinho's avatar
        harrinho
        Icon for Helper III rankHelper III
        8 years ago

        Don't know to be honest. It was there when I inherited the dashboard, so I don't really know the reason of its existence. It's the month_name in the form of "MMM", for example "Jan", "Feb" etc. but it doesn't seem to be used in any relationship.