Measure vs Calculated Column: The Mysterious Question? Not!

Despite all articles, blog posts, and videos on the topic of DAX Measures and Calculated columns, I still hear here and there that people ask what is the difference between Measure and Calculated Column? What situation should we use each of these? and on the other hand, what is the difference of creating column here, Read more about Measure vs Calculated Column: The Mysterious Question? Not![…]

Searching a Field or Table in Power BI Visualization: Power BI Helper

Last week, we announced the very first version of Power BI Helper. Power BI Helper is a tool that helps clean up a Power BI solution. This week we have an updated version with a new interesting feature: Searching for a Field or Table in all visualizations in the PBIX file. The additional feature is helpful for further Read more about Searching a Field or Table in Power BI Visualization: Power BI Helper[…]

Time series Series with Power BI- Forecast with Arima-Part 12

In the last posts (Series of Time Series), I have explained about what is ARIMA, what is d,p, and q in ARIMA (p,d,q). In this post, I will talk about how to use ARIMA for forecasting and how to handle the seasonality parameters. in the last example for the age of death of the England king, Read more about Time series Series with Power BI- Forecast with Arima-Part 12[…]

Power BI Cleanup Tool; Time Saving with Power BI Helper

Power BI files can easily get big. You can have 50 tables in a Power BI model, and 25 reports. When Power BI file gets in that size, maintenance is always an issue. It will take lots of time to find out if all of those 50 tables actually used in reports and visualization or not. Read more about Power BI Cleanup Tool; Time Saving with Power BI Helper[…]

Download Slides of Presentations in Power BI World Tour San Francisco

Power BI World Tour in San Francisco ran on 4th and 5th of October in Bay Area (Microsoft Sunnyvale). As a speaker, it is always a great opportunity for me and Leila to speak in such events and meet new people in the community. In San Francisco world tour, Leila and I presented 4 topics Read more about Download Slides of Presentations in Power BI World Tour San Francisco[…]

Time series Series with Power BI- Arima Model-Part 11

In the last post, I have explained the d value for model ARIMA (p,d,q). In this post, I am going to show how to identify the p and q values as below. one of the main difference between exponential smoothing and Arima is that Arima considers the correlation of a value at a time with Read more about Time series Series with Power BI- Arima Model-Part 11[…]

Ribbon Chart is the Next Generation of Stacked Column Chart

Earlier this month (September 2017), in the new version of Power BI Desktop, a new type of chart announced; Ribbon Chart. The very first look and feel of this chart are similar to Stacked Column Chart. The question that might come into your mind is that; why another way of showing the same thing? The Read more about Ribbon Chart is the Next Generation of Stacked Column Chart[…]

Basics of Value Structures in M – Power Query Formula Language

A couple of months ago, I’ve written a blog post about Basics of M and explained few basics about this language. In this post, I’m going to the next step and will explain few other structure definitions in this language. In this post, you will learn about Tables, Records, Lists, and how to navigate through Read more about Basics of Value Structures in M – Power Query Formula Language[…]

Create a Date Dimension in Power BI in 4 Steps – Step 3: Public Holidays

In last two steps you learned how you can create a date dimension that has calendar columns, and fiscal columns. In this step we are going to look at how Power Query can be leveraged to fetch public holidays live from APIs, and add that information into the date dimension. This step shows the importance Read more about Create a Date Dimension in Power BI in 4 Steps – Step 3: Public Holidays[…]