Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have on the same table, QuotaRegister, two columns dates. quota day and contable day.
The user should be able to choose which one.
The first idea was to make two tables : quotaday and contableday, but the original table is so huge, (4 gb)., that it spend many time with the data, load, deduplicate, transfer to the model data
My option has been to connect in the calendar table both columns and I have tried to use "userelationship" but I don´t have enought parameters.
Any idea?
Thanks.
Vergara
Solved! Go to Solution.
Hi@ Vergara
You may try to use CALENDARAUTO or CALENDAR function to create two CALENDAR table and create relationship respectively like below:
Then drag date into slicer respectively.
And these two calendar tables are not huge, and they will not cost much time with model data.
If not your case ,please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
Hi@ Vergara
You may try to use CALENDARAUTO or CALENDAR function to create two CALENDAR table and create relationship respectively like below:
Then drag date into slicer respectively.
And these two calendar tables are not huge, and they will not cost much time with model data.
If not your case ,please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
Thank you
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |