Look up previous transaction + Very slow

11097486 reason I asked about the data source, I would recommend to have this join/logic in the backend on SQL server rather than doing it in PQ. PQ is not great when it comes to grouping and merging/sorting etc. There are many technical blog posts around that but not going into detail.

You have two options:

- take this to the backend and do the data prep there (preferred method)

- or use Power BI dataflows, it comparatively much faster and you can schedule it to do the job, and then you can use Power BI dataflows in Power BI to visualize the data.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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.⚡