Tricia Taylor | Data Solutions

What data process do you need fixed?

Author: tnoeltaylor

  • How to Avoid Circular Dependencies – the Worst!

    —

    by

    tnoeltaylor
    in

    Circular dependencies in Power BI are frustrating, time-consuming, and can break your entire model. Here’s how to avoid them and keep your reports running smoothly. 1. Separate Measures from Calculated Columns Measures are dynamic and evaluated in the context of visuals. Calculated columns are static and stored in the model. Never design them to rely…

  • Creating a Running Total Across Multiple Data Sources in Power BI

    —

    by

    tnoeltaylor
    in

    Creating a running total in Power BI is usually straightforward—until you need to pull in Sales Orders, Material, and Customer Information from multiple tables. When those details matter (and they often do in real-world reporting), things get a bit more… fun. 😏 And if you’re using a Date Lookup Table? It won’t always help—especially when…