Forum Discussion
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 again I don't see how this could affect the relationship.
Any ideas, how could I address that?
9 Replies
Have you tried removing the calc column [Month Sort]
If the relationship can be added you can then just use.
MonthSort = Related(DIM_Month_Hierarchy[Number])
https://msdn.microsoft.com/en-us/library/ee634202.aspx
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.
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
Hi,
Create a new calculated column.
