• Power BI Pro Tip: LOOKUPVALUE() function

    Power Pivot is a great way to do data modelling and analysis right in Excel. It works great for data that is dimensionally organized (facts and dimensions) as well as other forms of data. It even enables…

  • Power BI Pro Tip: DIVIDE() function

    If you ever used Power Pivot to calculate things such as sales amount per capita or averages of some sort you will have run into the situation that the denominator (the column you want to divide by)…