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.
Hola, ¿Cómo podría hacer un porcentaje de rollo basado en los días anteriores en la tabla?
como tabla a continuación en el último coloumn (Negrita)
por ejemplo, en Excel para el 4 de enero, la fórmula sería =SUMA(C4:C7)/SUMA(D4:D7)
Col B | Col C | Col D | Col E | Col F |
Fecha | Total Faillure | Total de transacciones | Porcentaje diario de tasa de fallos | Tasa de fracaso porcentual de 2021 |
1-Ene | 33,356 | 133,439 | 25.0% | 25.0% |
2-Ene | 29,723 | 105,391 | 28.2% | 26.4% |
3-Ene | 20,482 | 69,621 | 29.4% | 27.1% |
4-Ene | 36,483 | 114,126 | 32.0% | 28.4% |
5-Ene | 27,479 | 87,791 | 31.3% | 28.9% |
6-Ene | 47,261 | 175,268 | 27.0% | 28.4% |
7-Ene | 59,169 | 228,002 | 26.0% | 27.8% |
8-Ene | 45,075 | 167,957 | 26.8% | 27.6% |
9-Ene | 30,831 | 111,596 | 27.6% | 27.6% |
10-Ene | 22,129 | 76,945 | 28.8% | 27.7% |
11-Ene | 36,722 | 127,618 | 28.8% | 27.8% |
12-Ene | 30,913 | 105,177 | 29.4% | 27.9% |
13-Ene | 30,414 | 103,153 | 29.5% | 28.0% |
14-Ene | 27,548 | 93,663 | 29.4% | 28.1% |
Solved! Go to Solution.
@NewbieJono , Con la ayuda de la tabla de fechas
Dividir(
CALCULATE(SUM(Table[Col C]),filter(allselected('Date'),'Date'[date] <=max('Date'[date]))) ,
CALCULATE(SUM(Table[Col D]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
)
o
Dividir(
CALCULATE(SUM(Table[Col C]),filter(allselected('Table'),'Table'[date] <=max('Table'[date]))) ,
CALCULATE(SUM(Table[Col D]),filter(allselected('Table'),'Table'[date] <=max('Table'[date])))
)
@NewbieJono , Con la ayuda de la tabla de fechas
Dividir(
CALCULATE(SUM(Table[Col C]),filter(allselected('Date'),'Date'[date] <=max('Date'[date]))) ,
CALCULATE(SUM(Table[Col D]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
)
o
Dividir(
CALCULATE(SUM(Table[Col C]),filter(allselected('Table'),'Table'[date] <=max('Table'[date]))) ,
CALCULATE(SUM(Table[Col D]),filter(allselected('Table'),'Table'[date] <=max('Table'[date])))
)
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 |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |