Running total error

teo9578 · ‎03-16-2022

Hi all.

I'm used 'quick measure' to make running total.

But, the return value is just the same as 'unit' column.

I expected running total, but it simply return the same value. Why is it? I would appreciate it if you could help me.

Anonymous · ‎03-23-2022

Hi @teo9578 ,

Create a measure like below:

measure = calculate(sum([unit]),filter(allselected('table'),[date]<=max([date])))

Best Regards,

Jay

parry2k · ‎03-16-2022

@teo9578 when working with dates, you should add date dimension in your model, check my YT series on the importance of date dimension here Learn basics of Time Intelligence DAX functions - Part 1 - YouTube

✨ Follow us on LinkedIn and to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.