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.
Tengo un problema tratando de obtener acumulado en Power bi.
Tengo compañía, cuenta y mes, y necesito obtener de acumulado por cada empresa, cuenta y mes.
Por favor, vea el ejemplo, el resultado es la columna Acumulado, ¿Cómo hacerlo?
Empresa | Cuenta | Mes | Cantidad | Acumulado |
1 | A | 2020-01-01 | 2 | 2 |
1 | A | 2020-02-01 | 34 | 36 |
1 | A | 2020-03-01 | 5 | 41 |
1 | B | 2020-01-01 | 4 | 4 |
1 | B | 2020-02-01 | 78 | 82 |
1 | B | 2020-03-01 | 4 | 86 |
1 | C | 2020-01-01 | 56 | 56 |
1 | C | 2020-03-01 | 89 | 145 |
1 | D | 2020-01-01 | 57 | 57 |
1 | E | 2020-01-01 | 58 | 58 |
1 | E | 2020-02-01 | 86 | 144 |
1 | F | 2020-01-01 | 69 | 69 |
1 | F | 2020-02-01 | 33 | 102 |
2 | X | 2020-01-01 | 6 | 6 |
2 | X | 2020-02-01 | 123 | 129 |
2 | X | 2020-03-01 | 123 | 252 |
2 | Y | 2020-01-01 | 8 | 260 |
2 | Z | 2020-01-01 | 56 | 56 |
saludos
Solved! Go to Solution.
Puede utilizar este código para una columna calculada:
Column = CALCULATE(SUM('Table'[Amount]), FILTER(ALL('Table'), 'Table'[Company] = EARLIER('Table'[Company]) && 'Table'[Account] = EARLIER('Table'[Account]) && 'Table'[Month] <= EARLIER('Table'[Month])))
@rcardenas1966 , Crear una nueva medida como
calculate(sum(Table[Amount]), filter(allselected(Table), Table[Company] á max(Table[Company]) && Table[Account] á max(Table[Account]) && Table[Month] <-max(Table[Month])))
O Nueva columna como
sumx(filter(Table, [Company] á earlier([Company]) && [Account] ? earlier([Account]) && [Month] <-earlier([Month])),[Amount])
Sorry!, I do not undertand some symbols.
calculate(sum(Table[Amount]), filter(allselected(Table), Table[Company] á max(Table[Company]) && Table[Account] á max(Table[Account]) && Table[Month] <-max(Table[Month])))
O Nueva columna como
sumx(filter(Table, [Company] á earlier([Company]) && [Account] ? earlier([Account]) && [Month] <-earlier([Month])),[Amount])
Thanks a lot, now is working, Ireview the other Solutions, Thanks
Puede utilizar este código para una columna calculada:
Column = CALCULATE(SUM('Table'[Amount]), FILTER(ALL('Table'), 'Table'[Company] = EARLIER('Table'[Company]) && 'Table'[Account] = EARLIER('Table'[Account]) && 'Table'[Month] <= EARLIER('Table'[Month])))
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 | |
1 | |
1 | |
1 | |
1 |