Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
MontherKH
Frequent Visitor

Date table relationships with other tables

 

I have a question regarding the following 3 tables which appear in the image below:

 

- Resources table (It contains a date field ("hire_date").

- ProductsResources table (it contains two date fields ("start", "end").

- Date table (Generated from CALENDARAUTO function)

DataModel.PNG

 

As you can see, the relationship between the Date and ProductsResources tables is inactive, also this inactive relationship is only between the "date" and "end" fields, I can't create a relationship between the "date" and "start" fields.

 

I have the two visualizations below which show that the date table works correctly only with the Resources table (the one on the right).

Tables.PNG

 

What should I do instead to make everything works?

1 REPLY 1
darkinvader_
Resolver I
Resolver I

Hi @MontherKH ,

you can use USERELATIONSHIP formula which will utilise your inactive relationship when that measure will run.
Could you please specify what you need so that I can provide you with a solution.

Please do gives a thumbs up if it helps you

Regards
Dark

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.