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…
A few years back when I was working on my first Power BI project for a large US life insurance client. I was working on a dataset with 40 million + rows and then faced issue in loading data into the Power BI Desktop. Due to large data in the Power BI Desktop, .pbix file…
Introduction In the dynamic realm of data analytics, Microsoft Power BI stands tall as a beacon of insights. For Mac users eager to harness this powerhouse for their analytical endeavors, the journey begins with a crucial question: How to download Microsoft Power BI on Mac OS/ Macbook? In this comprehensive guide, we unravel the intricacies,…
This article will show how to add measure in the slicer. Now the first question is why do we need to add a measure in the slicer? I got a situation where I have to roll up the granularity level and find the difference%, Difference bps, and bps range. To achieve it there are two…
Sparkline in Power BI has been a long-demanding feature in Power BI. I first heard about sparkline a few years back when I was attending corporate training on Tibco Spotfire. Sparkline is a tiny chart that helps to analyze the trend for each row as it is placed in each cell of the column in…
In this article, we will see step-by-step how to implement cross-report drill-through functionality. Cross Report Drill Through can be very useful when we want to reduce the size of each dataset which is extremely useful when there is a data size limitation based on license. Pre-Requisite for Cross Report functionality in Power BI While implementing…
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 making a report in Power BI, it is always a important point of consideration to know different options to share report with the end users. Also, it is always of great interest for anyone to know how can a power bi report be shared with non- pro users. Let`s discuss it in this article….
Most of the developers working on Microsoft Power BI face issues in two ways. First, the Microsoft Power BI Application installed on the machine is not working properly and the developer is facing problems in performing any task. Second, the issue is related to report optimization. Generally, it is the responsibility of the developer to…
Earth Soft`s EQuIS is a environmental data management solution which is used by large number of companies and government/private agencies around the world to store and manage environmental chemistry, biology, geology, hydrology, limnology, air related data. Now, in the recent May 2021 Microsoft Power BI update, EQuIS connector has been provided in Power BI so…