Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

can you please correct my dax?Anna min max recurring revenues = var min =…

  1. User

    can you please correct my dax?Anna min max recurring revenues = var _min = CALCULATE(MIN(''Chart of Accounts', 'Chart of Accounts'[INC CLASSIFICATION] = "Recurring Fees")), ALL('1 Dates') )) var _max = CALCULATE(MAX(''Chart of Accounts', 'Chart of Accounts'[INC CLASSIFICATION] = "Recurring Fees"))), ALL('1 Dates') )) return FORMAT(_min, "#0,0") & " | " & FORMAT(_max, "#0,0.0" ) & " " & UNICHAR(9650)

  2. Assistant

    Certainly! Here's the corrected DAX formula:

    Anna min max recurring revenues = VAR _min = CALCULATE(MIN('Chart of Accounts'[INC CLASSIFICATION]), 'Chart of Accounts'[INC CLASSIFICATION] = "Recurring Fees", ALL('1 Dates')) VAR _max = CALCULATE(MAX('Chart of Accounts'[INC CLASSIFICATION]), 'Chart of Accounts'[INC CLASSIFICATION] = "Recurring Fees", ALL('1 Dates')) RETURN FORMAT(_min, "#0,0") & " | " & FORMAT(_max, "#0,0.0") & " " & UNICHAR(9650)

    Please note that I made the following adjustments:

    • Removed the extra single quotation marks ('') within the CALCULATE function.
    • Fixed the closing brackets for the CALCULATE functions.
    • Specified the correct table name for 'Chart of Accounts'.
    • Moved the ALL function inside the CALCULATE functions to ensure it applies to the specific filter context.

    Feel free to adjust the table and column names as required.