Cannot create link between tables - Getting Ambiguity error - PLEASE help

[kskumar]

Dear Friends,

I have the enclosed DataModel for which am trying to create relationship between tables. 

https://drive.google.com/file/d/1jNS0BiKtHNSV9O9N4cYCezcnalcQad7h/view?usp=sharing

https://docs.google.com/spreadsheets/d/1Urui79xQOb2RPM2A4JVQsVF_ecwK1xD0/edit?usp=sharing&ouid=11583...

1. CategMaster - Category Master table

2. ProdMaster - Product & Category bridge table (a Category can have multiple Products)

3. Category Ratings - Category wise & date wise RAG ratings (it will have records for each month)

4. financials - Tables with actual sales data month wise & product wise (This table has the PRD ID that should be linked with "ProdMaster" (has actual sales only from 2013 to 2014)

5. YearlyTarget - Table with yearly sales target information (at Product Level - PRD ID & Fiscal year wise )

6. PrevYearActuals - Table with actual sales data - Fiscalyearwise & PRD ID wise (this has data only for year 2011-2012 & 2012-2013)

7. DateTable - Has Date & Fiscal year information

Points to Note:

-  Actuals sales information is spread in two tables (Yearly data for previous years in "PrevYearActuals" and Monthly data for year 2013 & 2014 in "financials"

- Fiscal year for my case is Jul to Jun

- Target Data is yearly sales target for all years (ie. from 2011 to 2014)

Current Challenge:

- When I create relationship between table "Category Ratings" and "DateTable", am getting ambiguity error. I could be wrong in the way I created the tables and thus I am encountering this error. 

Can someone PLEASE Help me to solve this error or PLEASE suggest ways.

Have enclosed my PBIX file and the source file for further reference. 

THANK YOU 

https://drive.google.com/file/d/1jNS0BiKtHNSV9O9N4cYCezcnalcQad7h/view?usp=sharing

https://docs.google.com/spreadsheets/d/1Urui79xQOb2RPM2A4JVQsVF_ecwK1xD0/edit?usp=sharing&ouid=11583...

Regards

Kumar

[Ashish_Mathur]

Hi,

I am not sure of what you are trying to accomplish but see if my suggested changes in the attached file work.

[kskumar]

Thanks @Ashish_Mathur , Can I confirm with you that you have added a column (date field) in "YearlyTarget" table and linked with DateTable.

May I know if you have made any other changes?

Let me check the visuals.

Thank you.

[Ashish_Mathur · Accepted solution]

You are welcome.  I had added a date column in 2 tables.  Study the model yourself to notice other changes made in the relationships.