Relationship error

[harrinho]

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? 

[Ashish_Mathur]

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]

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]

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]

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. 

[Ashish_Mathur]

Hi,

I'll need to see the file then.  Share the link from where i can download the file.

[harrinho]

Any idea how I can share a pbix retaining the data source confidentiality?

[v-jiascu-msft]

Hi @harrinho,

If there are errors even you don't try to create a relationship. Please check it out. Maybe you need a date table like this and then establish a relationship with CDL_Project_Forecast[full_date]. 

Datetable =
ADDCOLUMNS (
    CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2017, 12, 31 ) ),
    "Month", FORMAT ( [Date], "MMMM" )
)

Best Regards,

Dale

[Ashish_Mathur]

Hi,

Create a new calculated column.

[stretcharm]

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