Tag: excel table subtotal

Create A Lookup Table From Subtotals: Optimization In Power BI

In this tutorial, we’ll go through a technique that will create a lookup table from subtotals using the query editor in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This is most useful when we’re getting data out of Microsoft Excel because most of its data

Continue reading