Forum Discussion
Inactive Relationships
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
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.
2 Replies
- lbendlinSuper User
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_AdminAdministrator
Thanks a lot!!