CORRECT THE CODE: Anna min max recurring revenues = VAR min =…
- User
CORRECT THE CODE: Anna min max recurring revenues = VAR _min = CALCULATE(MIN(CALCULATE([P&L], FILTER('Chart of Accounts', 'Chart of Accounts'[INC CLASSIFICATION] = "Recurring Fees"), ALL(‘1 Dates’) ) VAR _max = CALCULATE(MAX(CALCULATE([P&L], FILTER('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
CORRECTED CODE:
Anna min max recurring revenues = VAR _min = CALCULATE(MIN(CALCULATE([P&L], FILTER('Chart of Accounts', 'Chart of Accounts'[INC CLASSIFICATION] = "Recurring Fees"), ALL('1 Dates') ))) VAR _max = CALCULATE(MAX(CALCULATE([P&L], FILTER('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)
- User
CORRECT CODE: Anna min max recurring revenues = VAR _min = CALCULATE(MIN('Chart of Accounts'[INC CLASSIFICATION] = “Recurring Fees”, ALL(‘1 Dates’)) VAR _max = CALCULATE(MAX('Chart of Accounts'[INC CLASSIFICATION] = “Recurring Fees”, ALL(‘1 Dates’)) RETURN FORMAT(_min, “#0,0”) & " | " & FORMAT(_max, “#0,0.0”) & " " & UNICHAR(9650)
- Assistant
CORRECTED CODE:
Anna min max recurring revenues = VAR _min = CALCULATE(MIN('Chart of Accounts'[P&L], FILTER('Chart of Accounts', 'Chart of Accounts'[INC CLASSIFICATION] = "Recurring Fees"), ALL('1 Dates'))) VAR _max = CALCULATE(MAX('Chart of Accounts'[P&L], FILTER('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)
- User
can you please replace this dax to include RoA & RoA target? - SVG Card Rectangular Shadow =
"data:image/svg+xml;utf8, " &
"
--- Glow Shadow ---
--- Outline ---
--- Section Title ---
<text text-anchor='left' font-size='15pt' font-family='Segoe UI' x='15' y='35'>"&MAX(MultiKPIs[Unit])&"</text>--- KPI Figure ---
<text text-anchor='left' font-weight= 'bold' font-size='30pt' font-family='Segoe UI' x='15' y='80' fill='"&MAX(MultiKPIs[RAG])&"'>"&IF(MAX(MultiKPIs[Measure])="Percentage",FORMAT(MAX(MultiKPIs[Actual]),"#%"),MAX(MultiKPIs[Actual]))&"</text>--- Goal Box ---
Goal: "&IF(MAX(MultiKPIs[Measure])="Percentage",FORMAT(MAX(MultiKPIs[Goal]),"#%"),MAX(MultiKPIs[Goal]))&"
------- Gauge------- <rect x="& "'"& 20+(200-(200-(MAX(MultiKPIs[Actual])/MAX(MultiKPIs[Goal]))*200)) &"'"&" y='100' width="& "'"& (200-(MAX(MultiKPIs[Actual])/MAX(MultiKPIs[Goal]))*200) &"'"&" height='20' /> Percent: "&'KPI'[KPI Percentage]&" "
- Assistant
"data:image/svg+xml;utf8, " &
"
--- Glow Shadow ---
--- Outline ---
--- Section Title ---
<text text-anchor='left' font-size='15pt' font-family='Segoe UI' x='15' y='35'>"&MAX(MultiKPIs[Unit])&"</text>--- KPI Figure ---
<text text-anchor='left' font-weight= 'bold' font-size='30pt' font-family='Segoe UI' x='15' y='80' fill='"&MAX(MultiKPIs[RAG])&"'>"&IF(MAX(MultiKPIs[Measure])="Percentage",FORMAT(MAX(MultiKPIs[Actual]),"#%"),MAX(MultiKPIs[Actual]))&"</text>--- Goal Box ---
Goal: "&IF(MAX(MultiKPIs[Measure])="Percentage",FORMAT(MAX(MultiKPIs[Goal]),"#%"),MAX(MultiKPIs[Goal]))&"
--- Return on Assets ---
RoA: "&IF(MAX(MultiKPIs[Measure])="Percentage",FORMAT(MAX(MultiKPIs[RoA]),"#%"),MAX(MultiKPIs[RoA]))&"
--- Target RoA ---
Target RoA: "&IF(MAX(MultiKPIs[Measure])="Percentage",FORMAT(MAX(MultiKPIs[RoA Target]),"#%"),MAX(MultiKPIs[RoA Target]))&"
------- Gauge------- <rect x="& "'"& 20+(200-(200-(MAX(MultiKPIs[Actual])/MAX(MultiKPIs[Goal]))*200)) &"'"&" y='100' width="& "'"& (200-(MAX(MultiKPIs[Actual])/MAX(MultiKPIs[Goal]))*200) &"'"&" height='20' /> Percent: "&'KPI'[KPI Percentage]&" "