Unified Date Filter

[Syndicate_Admin]

Good morning Community, hoping you are well
I need help with the following

I have a model where I have several columns of dates associated with events, by several I mean 5 or more,

These dates clearly do not coincide with each other, that is, they are not the same

Is there a way to have a date like MAIN that is based on the current year and when filtering it I include all corresponding columns, whether the event has been fulfilled or not.

Thank you very much in advance.
I remain attentive to any query

Best regards

[v-pnaroju-msft]

Hi Syndicate_Admin,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi Syndicate_Admin,

Thank you for your response.

We are pleased to know that the guidance provided was helpful. We encourage you to explore the USERELATIONSHIP function further, as it is a powerful tool for managing multiple date relationships effectively.

If you find our response useful, kindly mark it as the accepted solution and provide kudos. This will help other members in the community who may have similar queries.

Thank you.

[v-pnaroju-msft]

Hi Syndicate_Admin,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi Syndicate_Admin,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Thank you, @danextian, @Ashish_Mathur, for your response.

Hi Syndicate_Admin,

We would like to check if the solution provided by @danextian,@Ashish_Mathur has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.

Thank you.

[Ashish_Mathur]

Hi,

The data is not well structures to allow for filtering.  In the Query Editor, select all columns other than the date columns, right click and select "Unpivot Other Columns".  Create a Calendar Table and build a relationship from the Value column of your Fact Table to the Date column of the Calendar Table.

Hope this helps.

[danextian · Accepted solution]

Hi @Syndicate_Admin 

If a single table contains multiple date columns with potentially different values in the same row, it’s best to use a dedicated dates dimension table. You can then create multiple relationships from each date column to the dates table—one active (since only one active relationship is allowed at a time) and the rest as inactive. Use USERELATIONSHIP in a measure to invoke it. Similarly, if you have multiple tables and want them to be filtered by a common date field, you should use the same approach with the shared date dimension.

Those with broken lines in the image below are inactaive relationships

Please see the attached pbix for details.

[Syndicate_Admin]

Good afternoon, I hope you are well
Thank you very much for your answer and sorry for the delay
I've rarely used the USERELATIONSHIP feature, but it's the right thing to do with what I need, so we'll need to investigate it further.

Thanks a lot