Forum Discussion
One date slicer for different columns
Hey,
I'm importing data from google bigquery, i have 4 tables, all include a dateCompleted column but some of the data need to be sliced using userCreatedOn. how can i use one slicer for these different columns?
I think you can use 'userelationship' formula. You can link your calendar table to both datecompleted column and usercreatedon column. One line will be dot line. When you want to create meausre by that date column. You add userelationship formula in the measure to activate that relationship.
Thanks
2 Replies
ryan_mayuSuper User
I think you can use 'userelationship' formula. You can link your calendar table to both datecompleted column and usercreatedon column. One line will be dot line. When you want to create meausre by that date column. You add userelationship formula in the measure to activate that relationship.
Thanks
- jtownsend21
Responsive Resident
ryan_mayu Agreed. I would only add a note that whichever relationship is active is the default unless otherwise specified.
Also here is the doc for USERELATIONSHIP. https://docs.microsoft.com/en-us/dax/userelationship-function-dax
