Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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?
Solved! Go to Solution.
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 () )
Thanks,
Xi Jin.
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 () )
Thanks,
Xi Jin.
User | Count |
---|---|
65 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
86 | |
75 | |
56 | |
50 | |
45 |