Inactive Relationships

[Syndicate_Admin]

Good Community

I would like to make a query I have a table of facts that has 5 fields of Fechas_creacion,Fecha_modificacion,Fecha_inicio,Fecha_fin, Fecha_adjudicacion, apart I also have a calendar table associated with a date, my question is that I need to filter the records for each of the 5 date fields, only show the records filtered by a corresponding date but not make a calculation, I have been looking for some alternatives and I have seen that there are inactive relationships and I could filter using the USERELATINSHIP function, but I have doubts about how to use it since I only want to show the records in a table when I filter using a slicer to a specific date field.

attached example image filtering the table using Fecha_modificacion, the active relationship is with fecha_modificacion

[lbendlin · Accepted solution]

If you want to use slicers on the inactive date fields you will need to create separate calendar tables for these, or disconnected feeder tables and measures.

[Syndicate_Admin]

Thanks a lot!!