Setting default date filters in Power BI is a challenging task. if you need to filter to a certain date range such as Today, current month, the past 7 days, and so on. I am sharing a technique here on how to achieve it using DAX and Calculation groups. The technique shown here can be […]
Setting Default Dynamic Date Filters in Power BI Read More »
In this article/video, I am sharing a data visualization technique In Power BI to build an In-page navigation element using bookmarks and buttons to provide a user-friendly experience to navigate within a report page. When building reports in Power BI, it’s important to keep the layout simple and to show only the relevant visuals
How to create an In-Page Navigation with Bookmarks and Buttons in Power BI Read More »
I recently cleared the Exam DA-100: Analyzing Data with Microsoft Power BI. In this article, I share my experience on the preparations, resources that I used, practice questions links, and some important tips. If you plan to attend the DA-100 exam and earn the Microsoft Certified Data Analyst Certification, this article could be a useful read as I share
How I Prepared and Successfully Passed the DA-100 Microsoft Exam Read More »
In this article, I will be sharing a technique using List.Accumulate function to calculate the Exponential Moving Average (EMA) in Power Query. When it comes to recursive operations, the List.Accumulate is indispensable and becomes handy in scenarios of this nature. Read through the blog and download the attached PBIX file to learn more.I will be sharing a solution
Exponential Moving Average in Power Query (EMA) Read More »
I am sure people spend more time and effort cleaning and organizing their data when they need to perform data analysis in Excel, Power BI or any other tool. You do not always receive data in tabular and normalized formats for you to straightaway use the analysis tools like Pivot Tables, Filtering, Chatting and data
Pivot, Unpivot and Transpose Data with Power Query Read More »
Allocating amounts such as contracts, prepayment, revenue, cost, etc. across different date ranges is a common Excel challenge that can be solved in many ways. Let’s assume you have some rent contracts with start date, end date, and the amount which needs to be split into months based on the exact number of days in
Split Amount across Months Using Power Query in Excel and Power BI Read More »