Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Tengo la siguiente medida que me funciona bien al segmentar 1 año (ejemplo 2022), pero al segmentar 2 años (ejemplo 2022, 2021) me da error al leer datos, puede ser que el comando VALUES no sea el adecuado
% año actual2 = DIVIDE(CALCULATE(SUM(Consulta1[saldo_actual])),(CALCULATE(SUM(Consulta1[saldo_actual]),Consulta1[Etiqueta]= "Ingresos", Consulta1[year]= VALUES(Consulta1[year]), ALL())),0)
por favor tu ayuda
Solved! Go to Solution.
@hansaraneda , use in
% current year2 = DIVIDE(CALCULATE(SUM(Query1[current_balance])),(CALCULATE(SUM(Query1[current_balance])
,Query1[Label]= "Revenue", Query1[year] in VALUES(Query1[year]), ALL())),0)
Thank you very much for your help, it was the correct solution
@hansaraneda , use in
% current year2 = DIVIDE(CALCULATE(SUM(Query1[current_balance])),(CALCULATE(SUM(Query1[current_balance])
,Query1[Label]= "Revenue", Query1[year] in VALUES(Query1[year]), ALL())),0)
User | Count |
---|---|
84 | |
81 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
105 | |
96 | |
86 | |
68 |