cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pmbaranski
Frequent Visitor

Embedding a Case in advanced editor

Hi all,

 

I am trying to modify the below M code to also handle a case where if a column "PrevClose" is True then it will be displayed regardless of what VarToday is.

 

 

    #"Filtered Rows" = Table.SelectRows(
            #"Removed Columns", 
            let
                varToday = DateTime.Date(DateTime.LocalNow()),
                varLastDay = if Date.DayOfWeek(varToday) <= 2 then Date.AddDays(varToday, 3) else 
                if Date.DayOfWeek(varToday) >= 3 then Date.AddDays(varToday, 5) else 
                Date.AddDays(varToday, 1)
            in
            each [StartDate] <= varLastDay 
            ),

 

 

 

My first though would be to add an OR statement like the below, but it is not behaving as expected.

 

 

 each [StartDate] <= varLastDay or [PrevClose] ="True"

 

 

 The end goal of this is to display all jobs due to begin within the next 3 days, including jobs starting at any point in the future if the PrevClose is True. 

1 ACCEPTED SOLUTION
pmbaranski
Frequent Visitor

If anyone else is curious, the way i accomplished this is by adding a custom conditional column where PrevClose being True is equal to 1, and then inserting the OR statement like below; 

    #"Filtered Rows" = Table.SelectRows(
            #"Added Conditional Column", 
            let
                varToday = DateTime.Date(DateTime.LocalNow()),
                varLastDay = if Date.DayOfWeek(varToday) <= 2 then Date.AddDays(varToday, 3) else if Date.DayOfWeek(varToday) >= 3 then Date.AddDays(varToday, 5) else Date.AddDays(varToday, 1)
            in
            each [StartDate] <= varLastDay or [Custom] = 1),

View solution in original post

1 REPLY 1
pmbaranski
Frequent Visitor

If anyone else is curious, the way i accomplished this is by adding a custom conditional column where PrevClose being True is equal to 1, and then inserting the OR statement like below; 

    #"Filtered Rows" = Table.SelectRows(
            #"Added Conditional Column", 
            let
                varToday = DateTime.Date(DateTime.LocalNow()),
                varLastDay = if Date.DayOfWeek(varToday) <= 2 then Date.AddDays(varToday, 3) else if Date.DayOfWeek(varToday) >= 3 then Date.AddDays(varToday, 5) else Date.AddDays(varToday, 1)
            in
            each [StartDate] <= varLastDay or [Custom] = 1),

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors