Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to 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
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