Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
simple question for you, I'm sure.
I have a "IF" measure that works fine (moduling sum or average for a same field), I just want to add some "Format" arguments in it, can you help me please?
Here is the measure that works :
VarKPI2MonthlyActual =
IF('DATA(Update KPIs)'[SelectedValue] ="WS 3.5";
AVERAGE('DATA(Update KPIs)'[KPI 2 Monthly Actual]);
SUM('DATA(Update KPIs)'[KPI 2 Monthly Actual]))
Here is the measure that I want :
VarKPI2MonthlyActual =
IF('DATA(Update KPIs)'[SelectedValue] ="WS 3.5";
AVERAGE('DATA(Update KPIs)'[KPI 2 Monthly Actual]); FORMAT ('DATA(Update KPIs)'[KPI 2 Monthly Actual]);"Currency";
SUM('DATA(Update KPIs)'[KPI 2 Monthly Actual])) FORMAT ('DATA(Update KPIs)'[KPI 2 Monthly Actual]);"Percent"
it doesn't work, can you please help me ?
thanks !
Solved! Go to Solution.
VarKPI2MonthlyActual =
IF (
'DATA(Update KPIs)'[SelectedValue] = "WS 3.5";
FORMAT ( AVERAGE ( 'DATA(Update KPIs)'[KPI 2 Monthly Actual] ); "Currency" );
FORMAT ( SUM ( 'DATA(Update KPIs)'[KPI 2 Monthly Actual] ); "Percent" )
)
VarKPI2MonthlyActual =
IF (
'DATA(Update KPIs)'[SelectedValue] = "WS 3.5";
FORMAT ( AVERAGE ( 'DATA(Update KPIs)'[KPI 2 Monthly Actual] ); "Currency" );
FORMAT ( SUM ( 'DATA(Update KPIs)'[KPI 2 Monthly Actual] ); "Percent" )
)
@Anonymous
perfect !
so angry that syntax is not easy for me, but it should be.
I tried to encapsulate but it didn't work... 😞 now it is fine !
thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |