filtering files as datasource
Table.SelectRows(Source, each ([Extension] = ".csv") and ([Name] = "data-file-name.csv") and ([Folder Path] = "https://any-online-path-location/"))
Table.SelectRows(Source, each ([Extension] = ".csv") and ([Name] = "data-file-name.csv") and ([Folder Path] = "https://any-online-path-location/"))
root source location
= SharePoint.Files("https://<sharepoint_path>", [ApiVersion = 15])
filter filename
= Table.SelectRows(Source, each [Name] = "VendorMapping.csv")
filter last created
= Table.SelectRows(#"Filtered Rows", let latest = List.Max(#"Filtered Rows"[Date created]) in each [Date created] = latest)
Calendar =
VAR AllDates =
UNION(
SELECTCOLUMNS(t_expences, "Date", t_expences[ACC_PERIOD]),
SELECTCOLUMNS(WIBOR3M, "Date", WIBOR3M[Start of Month])
)
RETURN
CALENDAR(
MINX(AllDates, [Date]),
MAXX(AllDates, [Date])
)
where
- t_expences
- WIBOR3M
are tables which need shared dates.