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)))
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)))
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.
I can't see Date.IsInCurrentWeek anywhere in your code? If you could highlight, that would be great.
Thank you. At the very bottom. Let me know if this is not what you are looking for
Use this for your last step
= Table.SelectRows(#"Reordered Columns3", each Date.IsInCurrentWeek(Date.AddDays([Day of Week],-1)))