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.
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)
)
)
let
js = "
var text = '" & Text.Replace([COMMENT], "'", "\'") & "';
var vol = text.match(/(\d+[,\\.]?\d*)/)[0];
vol = vol.replace(',', '.');
document.write(vol);
",
html = "<script>" & js & "</script>",
result = Web.Page(html)[Data]{0}[Children]{0}[Children]{1}[Text]{0}
in
try Number.From(result) otherwise null