can you please correct my dax?Anna min max recurring revenues = var min =…
- 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)
- 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.