Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Load Latest Dates records in Power BI Query Editor

Hi,

 

I am new to Power BI. I have connected to Sql server and loading tables in Power BI to get the data.

I have data for all previous snapshot dates. from last 1 Quarter. I just want to load latest date records in my Power BI.

 

Currently, in Advance editor, I have written below script which is working fine. But I don't want to hardcode the value as in next load Max date will be different as we load data on every Friday.

    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [Load_Creation_Date] = #date(2018, 11, 23)),

 

I tried something like below:

 

    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [Load_Creation_Date] = Max(Load_Creation_Date))

 

but it's not working. Can anyone please help me?

Thanks!

 

Regards,

Poonam

 

 

Need Help
  • OwenAuger's avatar
    OwenAuger
    7 years ago

    Hi Poonam

    You can use the Power Query interface to filter on the latest Load_Creation_Date.

     

    In the Power Query editor, click the dropdown on the Load_Creaton_Date column => Date Filters => Is Latest.

     

    This should generate code looking like:

    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", let latest = List.Max(#"Removed Columns"[Load_Creation_Date]) in each [Load_Creation_Date] = latest)

    Regards,

    Owen

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Icon for Super User rankSuper User
    7 years ago

    Hi Poonam

    You can use the Power Query interface to filter on the latest Load_Creation_Date.

     

    In the Power Query editor, click the dropdown on the Load_Creaton_Date column => Date Filters => Is Latest.

     

    This should generate code looking like:

    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", let latest = List.Max(#"Removed Columns"[Load_Creation_Date]) in each [Load_Creation_Date] = latest)

    Regards,

    Owen