Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.