Two date columns in one table

[CalebG]

Hi! I currently have a table with a "Created On" and "Deactivated On" date. In my dashboard, I have these separated into two separate visuals but I want to have a date slicer that has the same effect on both. For example, if I want the date to be 6/1/2023 to 6/19/2023, I want the first table to show all cases created in that range and the second table to show the cases deactivated in that range. When I do this now it only accounts for the "Created On" date which gives me smaller results in the deactivated table. Does anyone know if there is a way to do this

[DOLEARY85]

Hi,

You'll need to have a date table with both the date fields joined to it. Then create measures that you use to calculate a count of records to be used in your charts and use the USERELATIONSHIP fucntion to switch the active relationship to whichever field you want to use.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍