Forum Discussion

harrinho's avatar
harrinho
Helper 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
Super User
8 years ago

Hi,

 

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

harrinho's avatar
harrinho
Helper III
8 years ago

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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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" )
)

     

    Relationship_error

     

    Best Regards,

    Dale