Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Using a +7 days as a filter. Daily refresh.

I'm having trouble finding my answer.

 

I'm building a Dashboard for warehouse operations. I want to include a number of item due out based on a due date from a file and include items that are due today +7 days. 

 

I want to display everything due out 7 days ahead with no limits in the past.

-Option 1 with filters?

-Option 2 by adding a calculated column in the query (requested date -X days)

 

Thanks in advance

 

Need Help
Tutorial Requests

1 Reply

  • mickey64's avatar
    mickey64
    Super User
    2 years ago

    For your reference.

     

    Step 1: I add a column 'Today_7' and change the type of column into 'Date' in Power Query Editor.

        Today_7 = Date.AddDays(DateTime.LocalNow() as datetime,7)

     

    Step 2: I add a column 'Flag' in Power Query Editor.

        Flag = if [due date]<[Today_7] then "No" else "OK"