Knowing Power Query function version compatibility

[Excelrati]

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.BetweenDelimiters is only available in Office 365? 

While Excel functions are clearly documented in Microsoft website from this aspect, I can't find  anything similar for M Query.

Thank you 

[#2]

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

[#3]

Thank you for the response.
It's sad to hear this is not available.
I'll use the workaround you provided.
Thanks again :smiling_face_with_smiling_eyes: