data source

[ashikts]

Hello Folks.

Thanks for the support .

once again i need help from this community .

I have a sharepoint data source which having excel files of workdata.

each day one workdata file will be updated in the sharepoint .

files name will be like 

workdata_day1

workdata_day2

workdata_day3 like that.

in the content ,there is not date column ,so only way to distinguish the files are by its filename.

entire folder is connected to the power bi environment .

my requirement is i need to create a table which contains the data from latest file only .how to achieve it ?

[smpa01 · Accepted solution]

let
    Source = SharePoint.Files("https://xyz.com/teams/Analytics", [ApiVersion = 15]),
    #"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([Folder Path], "test")),
    #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Date created", type number}}),
    #"Filtered Rows1" = Table.SelectRows(#"Changed Type", each ([Date created] = List.Max(#"Changed Type"[Date created])))
in
    #"Filtered Rows1"

@ashikts  you can filter the latest file based on Date created