Forum Discussion
Date Table
i have 2 data set 1 set comprises customer data which has 8/9 date columns which rang from 01-JAN-0199 to 31-DEC-9999 both of these ranges are from different date columns, however, 2nd data set conta...
HI AteeqSundhu,
Perhaps you can try to use unpivot columns feature on your date fields to convert them to attribute(raw field name) and value(date values).
Then you can link this new date value field with your calendar table and use the attribute to accurately control and filter on these records:
Unpivot columns - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng