Knowing Power Query function version compatibility

Hi All, While developing Power Query queries, how can I know whether the functions I'm using are available in the different versions of Excel? For example: how can I know that Text.BetweenDelim...

excel

Formulas and Functions

Lorenzo

Silver Contributor

May 12, 2023

Hi Excelrati

...I can't find anything similar for M Query

You're not the only one and the same applies to DAX. The only thing I can offer is the following query that lists the functions available on the Excel version where it's executed

let
    // #shared library excluding this workbook's Queries & custom functions
    Source = Record.ToTable(
        Record.RemoveFields(#shared,
            Record.FieldNames(#sections[Section1])
        )
    ),
    SelectedTypeFunction = Table.SelectRows(Source, each [Value] is function),
    RemovedValue = Table.SelectColumns(SelectedTypeFunction, {"Name"}),
    SortedRows = Table.Sort(RemovedValue,{{"Name", Order.Ascending}})
in
    SortedRows

Excelrati
Copper Contributor
May 12, 2023
Thank you for the response.
It's sad to hear this is not available.
I'll use the workaround you provided.
Thanks again 😊

Forum Discussion

Knowing Power Query function version compatibility

Resources