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

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