Isuue in data model (Urgent)

[prathmeshb27]

I am not understanding how to connect these two tables in data model.

Because of this I am unable to do the report. I am getting error as two tables are not related.

Can you tell me which fields to connect and how? what should be the cardinality and cross filter direction? 

Dataset link= 

https://docs.google.com/spreadsheets/d/1Nk2_y-cRXaJJb2q1KvhhwdoziqGNthqQ/edit?usp=sharing&ouid=10502...

Dashboard Requirements:

1. Broker Performance Tables:

• Construct "Top 10 Brokers" tables based on Gross Written Premium (GWP) for Open Market, Facilities, and Combined, in the 'Broker Stats' tab.
• Incorporate a new column showing the difference between actual and planned GWP as a percentage of the planned GWP.

3. Business Class Analysis Table:

• Using the 'Class Stats' tab, design a table showcasing Planned Premium, Earned Premium, and GWP for various business classes.
• Add columns to display Earned Premium and GWP as percentages of Planned Premium.

[Alex87]

1) I changed the data type for the column Year for the two tables

2) I created a relationship one to many from the dates table Date to the year as mentioned.

what exactly is not working for you in the provided solution?

[prathmeshb27]

Can you send this pbix file?

[Alex87]

I cannot upload a PBIX as I receive an error message. I suppose you are looking for the M code for the date table. You can find it here:

 Extended Date Table (Power Query M function) - Power Query / M Code Showcase - Enterprise DNA Forum

[Alex87]

Hello

Your two tables share 1 common field: Year. You need to transform the Year column to a date, for ex 2021 = 01/01/2021. The relationship in your model should be from a Dates table : Dates[Day] to the new Year Column for both Broker Stats & Class Stats (that are essentially your Fact Tables). Relationship will be One to Many. 

If it helps, please mark my reply as the solution. Thanks. 

[prathmeshb27]

The two tables are not getting connected with this model sir.

[prathmeshb27]

Not working. Can you make model and show ? as I have sent dataset link.