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

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

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

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

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

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

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

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

Fun with DAX – A-Maze-ing DAX

Intro: In my younger days, I enjoyed playing computer games and in particular, maze-based games. So for the latest addition to my series of DAX based games, I thought I would have a crack at building a game in Power BI that allowed the user to appear to control a character through a maze to Read more about Fun with DAX – A-Maze-ing DAX[…]

Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 1

For a month I am looking to create a Microsoft App that user able to take a picture from an invoice then able to see the items in Power BI or store it in storage such as SQL server, excel and so forth. In this posts, first I will show how to create a Power Read more about Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 1[…]

Fun with DAX – Mission Impossible

Further to my recent series of Power BI based games, I thought for this article I would build a version of the popular children’s game, Hangman.  To win the game, you need to guess a hidden word letter by letter, with the user having a number of “chances” with each wrong guess bringing you closer Read more about Fun with DAX – Mission Impossible[…]