In this blog, we will learn three incredible Power BI slicer tricks that will take your data visualization to the next level. From setting default selections in slicers to highlighting specific elements in visuals, these tricks will surely boost your Power BI skills.   3 Insanely Awesome Slicer Tricks in Power BI   The post 3 Insanely Awesome Slicer Tricks in Power BI appeared first on Goodly ..read more

We will be solving this problem in three parts Connecting to the SharePoint Folder Connect & Combine Excel files from SharePoint Connect & Combine CSV files from SharePoint Connect to SharePoint (the right way) https://youtu.be/ONACyfMvHSw   The post Connect Excel / CSV files from SharePoint to Excel or Power BI appeared first on Goodly ..read more

In this blog, I’ll show you a simple way to imitate the SWITCH function in Power Query. Since Power Query doesn’t have this function, I’ll demonstrate an easy technique that mimics it, helping you avoid complex nested IF statements.   SWITCH Function in Power Query The post SWITCH Function in Power Query appeared first on Goodly ..read more

In this blog, we will learn a neat calendar table trick in Power BI that helps eliminate spillover effects in your visualizations using a simple DAX trick.   Neat Calendar Table Trick in Power BI The post Neat Calendar Table Trick in Power BI appeared first on Goodly ..read more

Are you struggling to merge data from multiple PDF files into a single file while preserving its formatting? In this blog post, I’ll guide you through a step-by-step tutorial on how to combine multiple PDF files in bulk using Excel. Say goodbye to the tedious process of manual copying and pasting, which often leads to [...] The post Combine Data from Multiple PDF Files into a Single File in Excel appeared first on Goodly ..read more

In this blog, we will learn two ranking methods in Power BI – static ranking using Power Query formulas and dynamic ranking using DAX functions. We start with static ranking, where the rank is pre-calculated in Power Query before being pushed to Power BI. We’ll then explore dynamic ranking in Power BI, where ranks are [...] The post Dynamic and Fixed Rankings in Power BI appeared first on Goodly ..read more

In this blog, we will learn how to dynamically add multiple columns to our data using the List.Accumulate function. Often, we require adding columns to our data based on certain conditions, but manual addition can be time-consuming and non-flexible. With the List.Accumulate function, we can make the column addition process dynamic, expanding the number of [...] The post Dynamic Column Creation in Power Query Using List.Accumulate appeared first on Goodly ..read more

In this blog, you will learn to create a user-controlled column selection feature in Power Query. You will be able to select which columns you want to see in your Excel or Power BI file.   User-Controlled Column Selection in Power Query The post User Controlled Column Selection in Power Query appeared first on Goodly ..read more

In this blog, we’ll tackle a tricky DAX problem on how to compare tables in Power BI. I’ll walk you through the logic and steps to solve it. Tune in to boost your Power BI and DAX skills.   Compare Two Tables Using DAX in Power BI | Learn DAX by Example The post Compare Two Tables Using DAX in Power BI | Learn DAX by Example appeared first on Goodly ..read more

In this blog, we will learn how to perform a like-for-like comparison in Power BI. Often, when working with data in Power BI, you may need to compare data from the same time period in the previous year. Perform Like for Like Comparison in Power BI | A Time Intelligence DAX Case Study The post Perform Like for Like Comparison in Power BI | A Time Intelligence DAX Case Study appeared first on Goodly ..read more