Category: Power BI

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[…]

Substring in DAX: How to get Part of String Field in Power BI Using DAX Expression

Posted on by Reza Rad

Substring is one of the most common functions in many languages, However, there is no function named Substring DAX. There is a very simple way of doing it, which I am going to explain in this post. Substring means getting part of a string, for example from “Reza Rad”, if I want to get the Read more about Substring in DAX: How to get Part of String Field in Power BI Using DAX Expression[…]

Script for Creating TIME Table in Power BI with Hours, Minutes and Seconds Buckets

Posted on by Reza Rad

I have a Power Query script that I usually use in any Power BI solution that needs time-based analysis. However, I never had a chance to publish it here for everyone to use. So here it is. A friend’s question about a time table reminded me that it is good to publish this to the Read more about Script for Creating TIME Table in Power BI with Hours, Minutes and Seconds Buckets[…]

Search for All the Texts in Power BI Table Visual with the First Three Characters Selected in the Slicer

Posted on by Reza Rad

Yesterday, I published a post about having a slicer that filters the rows in a table visual in Power BI that contains the characters from that slicer. A friend asked me what if we want to search for the first few characters? that means selecting the first character, then seeing all the possible second characters, Read more about Search for All the Texts in Power BI Table Visual with the First Three Characters Selected in the Slicer[…]

Search in Power BI Table Visual Using a Slicer For Contains Character Criteria

Posted on by Reza Rad

If you have a lot of text in a table visual in Power BI and want to search to find all texts with a specific character in it, I have a solution for you. You can have an alphabet slicer and use it to filter the table visual, the trick is to combine it with Read more about Search in Power BI Table Visual Using a Slicer For Contains Character Criteria[…]