Wrong DAX filtered table

[Anonymous]

Hi guys

Could you please let me know what is wrong with this formula?

Mondays = FILTER('Summary Report', RELATED('Calendar'[Weekday])= "Mon")

I'm trying to create a table of the Summary Report, but with the dates all on mondays

The result is all records with tuesdays...not mondays. I've tried to subtract 1 but didn't work....
Any ideas?

[Anonymous · Accepted solution]

It is giving right value as I just recreate the issue at my end. Can you check your calender table Weekday formula, its second parameter should be set to 1. 

[Anonymous]

Hi @Anonymous 
Thank you so much (i'm so bad....don't know why i had a 2 instead of a 1....)
Awesome!!!!