I am using Power BI Date Table Code for creating calendar in my data model.
Presently, this code ask 3 parameters . 1) StartDate 2) EndDate 3) FYStartMonth
I want to add another parameter (DayOfWeekName) for week & month cut-off.
e.g. if I select Thursday then all Thursday date will be marked as week cutoff and last Thursday of month as month cut-off.
The .pbix file is attached. Presently, I have achieved required result using groupby & merge query option.
WeekCut-off & Month Cut-off are required columns in Date table.
Looking for better approach through parameter in Power BI Date Table Code.
Week & Month Cut-off table in Calendar.pbix (34.1 KB)
Power BI Date Table code.txt (2.8 KB)
Thanks in advance