Filer Day.IsInCurrentWeek to start on Monday

[rhaberkorn4]

Hello,

I am trying to crete a simple spread sheet using and ODBC connection and Power querry. I data dump the ODBC connection into excel and then use that table in Power querry. 

There is a Day of Week going back at least (2) years. I really only care about 'This Current' Week. I filter on 'Day.IsInCurrentWeek' and it starts on a Sunday. I would like it to start Monday to Sunday. 

I have read multiple forms and watched YouTube but my M Coding is not where it needs to be.  Any help would be apprecietated. Thank you

[Vijay_A_Verma]

If you want to use Monday as the start day for Date.IsInCurrentWeek, use 

Date.IsInCurrentWeek(Date.AddDays([Date],-1))

Hence, you will have to insert following step where #"Changed Type" is previous step

= Table.SelectRows(#"Changed Type", each Date.IsInCurrentWeek(Date.AddDays([Date],-1)))

[rhaberkorn4]

Thank you,

I tried to enter the code you porovided into the advanced editor and it is giving me error.  I have attached the current advianced editor code.

[Vijay_A_Verma]

I can't see Date.IsInCurrentWeek anywhere in your code? If you could highlight, that would be great.

[rhaberkorn4]

Thank you. At the very bottom. Let me know if this is not what you are looking for

[Vijay_A_Verma]

Go to UI - Click on Filtered Rows1 in right pane - In Formula bar, delete everything and copy my code..

[rhaberkorn4]

THANK YOU! I am sorry if this was very frustrating. I really apprecieate your help. This worked. 

Thank you thank you thank you!

[Vijay_A_Verma · Accepted solution]

Use this for your last step

= Table.SelectRows(#"Reordered Columns3", each Date.IsInCurrentWeek(Date.AddDays([Day of Week],-1)))

[rhaberkorn4]

I am so sorry. I am not getting this. Does that code go in place of the #"Filtered Rows1" or after? Does the very last line "in #Filtered Rows1" need to be changed after that. I put the code in and I just get this response.