DAX

Lookupvalue function is one of the important function in dax which allows users to get corresponding row value from another column based on row value of a column. So lets discuss a use case in order to understand the way lookupvalue function is used in Power BI. Problem Statement Lets Suppose we have got three …

How to use lookupvalue function in Power BI? Read More »

I recently worked upon a scenario where I have shown all the selected values in slicer in a Card. So, Card basically acts as a display screen which shows all the selected values in the slicer. The scenario which I just mentioned is very relevant and practical from reporting perspective with an intention to show …

PowerBI : How to Display multiple selected values in a Card? Read More »

I was sitting here in my home thinking what to write for my next article on my blog. I thought about what could be most helpful for my readers. When I was in my initial learning days I found that DAX is the most important language in PowerBI. With the help of DAX, you can …

Best Resources to learn DAX Read More »

In this article, let’s prepare a demo for Relative Date using DAX Expression in PowerBI. Relative Date means When you select a date in Slicer then last n days data get analyzed with respect to any measure. For more details, read the article below. I got a ping from a friend that he wants only …

DIY 2 : How to achieve Relative Date filtering in Power BI Read More »

Here, I will be discussing a very important dax function TREATAS which can be used to establish a virtual relationship between tables. I will provide steps that will help you to master this function. Virtual Relationships are a very important concept in Dax. Whenever it is difficult to establish a relationship between two tables. A …

Virtual Relationship in Dax | Demo with TREATAS Function Read More »