Power Query M - Filter last two days

[Saint_jordi]

Hello, I'm trying to write a formula to filter rows based on the "ReferenceDate" field.

The problem is:

If today is monday, filter today, (last) sunday and (last) Saturday.

else filter today and yesterday;

I wrote this code, but it seems to have a syntax error on the first "ReferenceDate"

Please Login or Register  to view this content.

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.