Tag: Power BI Lookup Table

Data Model For Power BI Retail Sites Dashboards

Data Model For Power BI Retail Site Dashboards

In this tutorial, you’ll learn about developing a data model for Power BI Retail Sites Dashboards. The methods discussed will help you harvest valuable insights easily from your report. From start to finish, you’ll see how amazing DAX formulas are in calculating and filtering results for you to harvest and gather. Arranging The Data Tables

Continue reading

Calculated Columns Power BI: Tips & Best Practices

Best Practices When Using Calculated Columns In Power BI

This tutorial will discuss the best practices in using calculated columns in Power BI. We’ll also be going through the DAX formulas used to create them. In previous discussions, we’ve gone through how to write different measures in Power BI, but another technique we can use is to create calculated columns. Other than measures, using

Continue reading

Connecting Data Tables – Tips on Power BI Relationships

Now that I’ve discussed what data modeling is, it’s time to understand what Power BI relationships among different tables can do for your reports. You may watch the full video of this tutorial at the bottom of this blog. Different data sources within your models need to have the right relationships to yield the right

Continue reading

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