Running Totals Take Forever Need Some Direction

Howdy - I have what I think is a rather simple problem. I have a table with about 800K rows in it. There's a date column, an hours column, a customer column and a sales column. I'd like for the r...

Need Help

parry2k
4 years ago
JLEmlet fundamentally you are missing a calendar dimension in your model, any time intelligence-based calculations should be done using Date/Calendar dimension in the model and it is a best practice. Add a calendar dimension, you can follow my blog post to add one and in your measure, replace all the references to the calendar dimension and the column from this dimension and it should be lightning fast.

Create a basic Date table in your data model for Time Intelligence calculations | PeryTUS IT Solutions

You can always find a workaround but I would hate to advise those and highly recommend adding a Calendar dimension in your model.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.⚡

Forum Discussion

Running Totals Take Forever Need Some Direction