The BI Journey

Tag: Power BI

  • Pareto rule in DAX (refreshed)

    —

    by

    Jani Zajc
    in

    Quite some time ago, before all the improvements of DAX, I wrote a post on how to create a Pareto chart in Power BI. Now, it’s time for a re-run with the more recent features of DAX, mainly window functions! So, let’s try to write the Pareto cumulative sum of a metric (in the example…

  • Aggregations in Power BI

    Aggregations in Power BI

    —

    by

    Jani Zajc
    in

    There are three main points of advantages in using aggregations (what we can get from the official documentation): Better query performance over big data Optimized data refresh Balanced architectures First, I connet to the AdventureWorksDW database. We choose a couple of tables (fact + dimension): Connect the tables into a data model Now, to have…