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.

add new blank query and...
= Table.FromList(Table.ColumnNames(your_table_name), Splitter.SplitByNothing())

use in DAX query view

EVALUATE
INFO.CALCDEPENDENCY()

___test = 
FILTER(
    t_expences,
    t_expences[EXP_DATE] = CALCULATE(
        MAX(t_expences[EXP_DATE]),
        ALL(t_expences)
    )
)