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 Everyone,
I'm at an absolute loss as to how to calculate a cumulative total without data.
I tried something like this:
Solved! Go to Solution.
@JoanElGran1899
Not quite understood the model but can you try the following measure to get the accumulation based on the account number which I think is 'Cuenta Contable'
Total acumulado GL =
var __acc = MAX(Table1[Cuenta Contable]) return
CALCULATE(
[IMPORTE],
FILTER(
ALLSELECTED(Table1[Cuenta Contable]),
Table1[Cuenta Contable] <= __acc
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@JoanElGran1899
Not quite understood the model but can you try the following measure to get the accumulation based on the account number which I think is 'Cuenta Contable'
Total acumulado GL =
var __acc = MAX(Table1[Cuenta Contable]) return
CALCULATE(
[IMPORTE],
FILTER(
ALLSELECTED(Table1[Cuenta Contable]),
Table1[Cuenta Contable] <= __acc
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
It was exactly what i was looking for! 😉
Thank you so much.
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 |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |