One date slicer for different columns

[rawad]

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?

[ryan_mayu · Accepted solution]

@rawad

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]

@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