dynamic select a period time

[Anonymous]

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

[v-lili6-msft · Accepted 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

[Anonymous]

Thank you