This blog will demonstrate the best method of adding a conditional index column on Power BI. Using the Power Query, we’ll add an index number from 1 for each ID in the table and begins in the row after the values in the date columns hit more than or equal to 90. You can watch
In this Power Query tutorial, we’ll examine a unique and intriguing Power Query Group By Alphabets to Columns Excel BI Challenge. It involves turning a single-column table into a table where each letter has its column and is repeated as often as it is present in the source table. You can watch the full video
This blog will examine the Stacked to Ordered Data Challenge from Excel BI, involving the Power Query transform column to table functions. The task is to turn a single column of data into a proper table where each type of data has its column and subsequently will add a rank on population. You can watch
In this tutorial, you’ll learn a Power Query optimization technique to reduce RAM usage. Specifically, you’ll learn how to reduce the numbers stored after a decimal place. This is helpful if you’re dealing with columns stored in a decimal number format. In this example, you can see that the Net Price is consuming 11MB of
In this blog post, we’ll talk about the difference between Conditional and Custom Columns in Power BI. We’ll also show examples of when and how we can use them, including some of their alternatives. Custom columns require a different formula language that we need to learn first. On the other hand, conditional columns are easy
