Forum Discussion

Mahmed1's avatar
Mahmed1
Icon for Helper IV rankHelper IV
3 years ago
Solved

Filter import date to latest date on that date

Hi   i have a dataset where i have multiple import dates on a given date   what i need to do is look at the date and then go back to previous week of import date and then get the latest import da...
Need Help
  • Mahmed1's avatar
    Mahmed1
    3 years ago

    I think this could work

    Find max import date

    then check to see if that max date = import date

    of yes then filter that

     

    i know what i want ti achieve but cant put it in a power query formula

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    3 years ago

    It picks up the first value of table through Table.FirstValue which is the date in your case.

    Corresponding to this date, it finds the last Sunday which is 23-Jul for 26-Jul date. Then it will generate Monday (17-Jul) to Sunday (23-Jul) list. 

    Filter will select only those rows where Import date lies in this list of dates.

Mahmed1's avatar
Mahmed1
Icon for Helper IV rankHelper IV
3 years ago

Thank you

 

i will give this a try

 

is there any chance you can explain how the code works?

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
3 years ago

It picks up the first value of table through Table.FirstValue which is the date in your case.

Corresponding to this date, it finds the last Sunday which is 23-Jul for 26-Jul date. Then it will generate Monday (17-Jul) to Sunday (23-Jul) list. 

Filter will select only those rows where Import date lies in this list of dates.