Forum Discussion

rhaberkorn4's avatar
rhaberkorn4
New Member
2 years ago
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...
Need Help
Tutorial Requests
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    2 years ago

    Use this for your last step

    = Table.SelectRows(#"Reordered Columns3", each Date.IsInCurrentWeek(Date.AddDays([Day of Week],-1)))
rhaberkorn4's avatar
rhaberkorn4
New Member
2 years ago

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

 

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
2 years ago

Use this for your last step

= Table.SelectRows(#"Reordered Columns3", each Date.IsInCurrentWeek(Date.AddDays([Day of Week],-1)))
  • rhaberkorn4's avatar
    rhaberkorn4
    New Member
    2 years ago

    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.