Forum Discussion
Solved
Filer Day.IsInCurrentWeek to start on Monday
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 D...
Use this for your last step
= Table.SelectRows(#"Reordered Columns3", each Date.IsInCurrentWeek(Date.AddDays([Day of Week],-1)))
Go to UI - Click on Filtered Rows1 in right pane - In Formula bar, delete everything and copy my code..
THANK YOU! I am sorry if this was very frustrating. I really apprecieate your help. This worked.
Thank you thank you thank you!