Please find the attached workbook. I have created custom dates as below.
and then select below option.
Then put this newly created date in the filter section.
Create a calculated field as below.
DATENAME('weekday',[Order Date (Days)])
Please see the below screenshot and confirm the output.
Validation for the same.
Thanks and Regards,
Dayname wise count.twbx 339.8 KB