cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pntlindsay Frequent Visitor
Frequent Visitor

Date Relationship Problem

pbr-issue.jpg

 

Hello,

 

Despite reading a lot of material about this issue I am not able to achive the soluntion I require.

I basically have 2 key tables.  Sales information that include date and salesrep and a tabel containing monthly sales targets for salereps.  I require 2 types of analysis:  Sales information by salesrep against target and sales information for each salesrep per month against target.  I can achieve the first by creating a linking table of  Salesreps.  However I am not able to create a second linking table for months without making the link to Salesreps inactive.  Documentation suggests creating a copy of tables but I dont understand how this would work.

 

I would really appreciate help to solve this, since this must be a very common issue.

 

Thanks, Phillip

 

 

1 REPLY 1

Re: Date Relationship Problem

There is a lot to learn. I recommend reading my 2 articles here first. 

https://exceleratorbi.com.au/relationships-power-bi-power-pivot/

https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/

 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors