Tag: Fact Tables

Power BI Calculated Column vs Measure: A Comparison

In this blog, I’m going to compare Power BI calculated column and measures, and then cover some of their differences. You may watch the full video of this tutorial at the bottom of this blog. I’m also going to show you optimal situations where you can use either of them. Creating Calculated Columns I’m going

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

Manage Multiple Date Calculations In Your Fact Table – Advanced Power BI Technique

In this tutorial, I’m going to teach you how to manage multiple date calculations in your Fact Table in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This is a frequent question in the Enterprise DNA Support Forum. These multiple dates could be order dates, ship

Continue reading