Forum Discussion
Filer Day.IsInCurrentWeek to start on Monday
Use this for your last step
= Table.SelectRows(#"Reordered Columns3", each Date.IsInCurrentWeek(Date.AddDays([Day of Week],-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)))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.
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!