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…
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…
Are you interested to learn Microsoft Power BI? Are you searching for Microsoft Power BI Tutorials? Your search stops here!!Microsoft Power BI Tutorials article is created to help people who have started learning Microsoft Power BI but do not know exactly where to study or what to study and how to study. I will provide here steps to…
What is Corona Virus? Corona Virus ( COVID-19) is a severe acute respiratory syndrome disease caused by the SARS-COV-2 Virus. It is first identified in Wuhan Province China in December 2019. WHO has declared it pandemic on 11 March 2019 as it is believed to spread in 115 Countries across the Globe. As per John…
Why do you need Free Public Data Sets? Free Public Data Sets are essentially required in order to use it in Data Science and Machine Learning Projects. Some of the latest datasets are being published by some of the top research institutions in the world which can be used by developers around the globe…
My Friend got a Scenario where he was asked to subtract the prior value from the current value of the column. I helped him by finding the Solution on the Microsoft community I did not find the correct solution on it. I have prepared the demo for describing the solution for the problem “Subtracting Prior Value from…
I got a scenario to convert the Seconds to HH:MM:SS in Power BI. Step 1: Click on Edit Query and go to the query having seconds in the Column. Below is the screenshot of the Query. The table is “TimeTable” and Column having second Value is “Seconds” Step 2: Go to Add…