Forum Discussion

Excelrati's avatar
Excelrati
Copper Contributor
May 12, 2023

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.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 

excel
Formulas and Functions

2 Replies

  • Lorenzo's avatar
    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's avatar
      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 😊

Resources