Difference between  sum of values for recent date and 2nd most recent date.

Difference between sum of values for recent date and 2nd most recent date.

      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…

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

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

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…

DIY4 :  Learn to use LOOKUPVALUE DAX Function in Power BI using Example

DIY4 : Learn to use LOOKUPVALUE DAX Function in Power BI using Example

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…

DIY 3 : Learn to achieve Conditional Running Total in PowerBI using Example

DIY 3 : Learn to achieve Conditional Running Total in PowerBI using Example

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…

DIY 1 : How to do  Conditional Formatting using field value  in Power BI

DIY 1 : How to do Conditional Formatting using field value in Power BI

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…

Virtual Relationship in Dax | Demo with TREATAS Function

Virtual Relationship in Dax | Demo with TREATAS Function

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…