Category: Power BI from Rookie to Rockstar

Remove Columns with Specific Patterns Name in Power BI using Power Query

Posted on by Leila Etaati

I was in the middle of data transforming to create a clean dataset for a Charticulator post, that I come across a dataset as http://mdgs.un.org/unsd/mdg/SeriesDetail.aspx?srid=749 This dataset is for Carbon dioxide emissions in different countries around the world. The only columns I need from this datasets is about country name and the number of emissions for Read more about Remove Columns with Specific Patterns Name in Power BI using Power Query[…]

Offset Columns for the Date Table: Flexibility in Relative Date Filtering for Power BI

Posted on by Reza Rad

I have written previously provided an all-in-one script for the date dimension, and also wrote an article about the relative date slicer. However, sometimes you cannot use the relative date slicer (timezone issue can be one example), adding offset columns help to overcome that challenge, and still be able to do flexible relative filtering in Read more about Offset Columns for the Date Table: Flexibility in Relative Date Filtering for Power BI[…]

CDS and CDM are Not the Same! Difference Explained

Posted on by Reza Rad

Working with Power BI and Power Platform dataflows, or using Dynamics in general, might cause you to hear one of these two CDS (Common Data Services), or CDM (Common Data Model). Often there is a misconception about these two, and many people think they are the same. In this article, I’ll explain the difference between Read more about CDS and CDM are Not the Same! Difference Explained[…]

Relative Date Slicer in Power BI; Simple, yet Powerful

Posted on by Reza Rad

If you are using a date slicer in your Power BI report, a relative date slicer is one of the options to consider for sure. This is a very simple type of slicer to use, but very effective in terms of options that it provides for the user to slice and dice the data. Let’s Read more about Relative Date Slicer in Power BI; Simple, yet Powerful[…]

Fibonacci Sequence: Understanding the Power Query Recursive Function for Power BI

Posted on by Reza Rad

Recursive functions in Power Query are not very popular, but sometimes very helpful when in need. In this post, I’ll explain what a recursive function is, how it works, and explain it through a famous recursive example of Fibonacci Sequence. Fibonacci Sequence Fibonacci sequence is one of the fundamental recursive operations in math, below are Read more about Fibonacci Sequence: Understanding the Power Query Recursive Function for Power BI[…]

Get Data from Multiple Excel Files with Different Sheet Names into Power BI

Posted on by Reza Rad

The ability to use Get Data from Folder in Power BI is a very useful option. However, if your sheet names are different in the list of Excel files, then you will face a problem. In this blog article, I’ll explain a method you can use that works regardless of the sheet names. Sample Dataset Read more about Get Data from Multiple Excel Files with Different Sheet Names into Power BI[…]

Get the Day of the Week Name and Number in Power BI Using DAX

Posted on by Reza Rad

If you don’t have a date table with a column that represents the day of the week name (Saturday, Sunday, Monday etc) or number (from zero to six, or from one to seven), and you just have a date field, which you want to quickly get the day name of the week, here is a Read more about Get the Day of the Week Name and Number in Power BI Using DAX[…]

Power BI DAX Back to Basics: Scalar Vs. Tabular Functions

Posted on by Reza Rad

DAX is the analytical language in Power BI. Learning this language, however, comes with some difficulties. Part of that challenge is the way that functions work in DAX. Learning the output of functions is an important element of learning how and where you can use them. In this article, I’ll explain two types of outputs Read more about Power BI DAX Back to Basics: Scalar Vs. Tabular Functions[…]

Power BI Desktop Download or Microsoft Store App? Which One?

Posted on by Reza Rad

If you want to develop Power BI reports, you’ll need the Power BI Desktop application. However, Power BI Desktop application comes in two ways; Download it separately and install it on your Windows machine, or Get it from Microsoft Store as an App. The question that I often get is; What is the difference? which Read more about Power BI Desktop Download or Microsoft Store App? Which One?[…]

Q&A Visual in Power BI Desktop

Posted on by Leila Etaati

In this post series, I am going to show how to use new Q&A visuals for the aim of creating easy visuals by typing the natural language and define some user-defined terms and how to manage it. This visual is now generally available for everyone. IN this post some introduction to this visual about how Read more about Q&A Visual in Power BI Desktop[…]