Forum Discussion
Two date columns in one table
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...
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 👍