DAX function Networkdays is the latest addition to the existing DAX formulas having a crucial requirement as it helps to find the number of working days between two dates considering weekends and holidays in Power BI. Networkdays function used to exist in excel but was missing in the Power BI DAX formulas list. So it…
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…
While going through the Microsoft Power BI Community, I saw a post where a fellow member was asking for a solution to the problem in getting the difference between the sum of values for the most recent date and Just the previous date. I worked to find a solution for the problem…
While working on the scenario “How to refresh dataset using button in Report view of Power BI?”, We have added a DAX function UTCNOW() which will give the refresh time and date value in a card. But the value in the card will be in the UTC and we are more interested to show the…
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…
I was sitting here in my home thinking about 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…
I was solving a problem on Microsoft Power BI Community which proved to be the best use case for LOOKUPVALUE function in PowerBI. So finally, I decided that I will write a blog about it so that my readers understand where and how to use the LOOKUP VALUE Function in PowerBI. What is the LOOKUPVALUE…
Again while solving the problem on Microsoft PowerBI Community, I got a problem related to the Conditional Cumulative Sum/Running Total so I thought to put that problem along with a solution for my readers here. You can practice it and gain a lot of valuable experience in Power BI. Well, I am running Microsoft PowerBI DIY…
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…
Here, In the article, I am going to share a very general use case i.e to show a message that slicer is not selected on the top of a visual if nothing is selected in the slicer. Showing and Hiding Visuals such as Table/Gauge/Matrix is generally used in the Power BI report. In order to…