I have 2 dataset,
1- Employee Master which has employee details including Date of Joining(DOJ) and Date of exit(DOE)
2- Have created a Calendar master dataset
Now i am trying to join Date column from calendar table to column in employee masters DOJ and DOE such that i can use them to do calculation but i am not able to connect both of them at a time.
In powerBI we had a function userelationship, using which we can connect 2 dataset with multiple columns and dedice when to use what connection. Is there a similar workaround for this in quicksight or any inbuilt calendar function which i can use directly in my employee master table.