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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
jlutz
New Member

How to display related records between table X and Calendar table if relationship is INACTIVE?

I have a single Calendar table with multiple other tables related to it by date.  All of the relationships are "inactive" to avoid circular references et cetera.  For my measures, it's easy enough to use USERELATIONSHIP to specify which relationship to use.

 

However, I have a Table visual, and I want to display all of the records related (via one of the inactive relationships) between table X and my Calendar table.  

 

How can I do this?   

1 ACCEPTED SOLUTION
v-xjiin-msft
Solution Sage
Solution Sage

@jlutz

 

To achieve your requirement, you can refer to following method:

 

1. Create measures to get the Max and Min date of Calendar table with expression like:

 

StartDate =
CALCULATE ( MIN ( 'Calendar Table'[Date] ), ALLSELECTED ( 'Calendar Table' ) )

2. Create a measure in your source table to filter the records:

 

Flag =
IF (
    MAX ( Table3[Date] ) >= [StartDate]
        && MAX ( Table3[Date] ) <= [EndDate],
    1,
    BLANK ()
)

1.PNG

 

Thanks,
Xi Jin.

View solution in original post

1 REPLY 1
v-xjiin-msft
Solution Sage
Solution Sage

@jlutz

 

To achieve your requirement, you can refer to following method:

 

1. Create measures to get the Max and Min date of Calendar table with expression like:

 

StartDate =
CALCULATE ( MIN ( 'Calendar Table'[Date] ), ALLSELECTED ( 'Calendar Table' ) )

2. Create a measure in your source table to filter the records:

 

Flag =
IF (
    MAX ( Table3[Date] ) >= [StartDate]
        && MAX ( Table3[Date] ) <= [EndDate],
    1,
    BLANK ()
)

1.PNG

 

Thanks,
Xi Jin.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors