Tag: Power BI Columns

Adding a Conditional Index Column in Power BI

Adding a Conditional Index Column in Power BI - Enterprise DNA

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

Continue reading

Using Power Query Group By In A Data Challenge

Using Power Query Group By In A Data Challenge - Enterprise DNA

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

Continue reading

Power Query Transform Column Challenge: Stacked Data to Ordered Table

Power Query Transform Column Challenge Stacked Data to Ordered Table - Enterprise DNA

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

Continue reading

Power Query Optimization: Reducing Decimal Numbers

Power Query Optimization Reducing Decimal Numbers - Enterprise DNA

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

Continue reading

Custom Columns In Power BI Vs. Conditional Columns

Custom and Conditional Columns

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

Continue reading