Tag: Power BI Advanced Data Transformations & Modeling

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

Power BI Filtering Techniques For Tables

Power BI Filtering Techniques For Tables

In this blog, we’re going to learn about some essential Power BI filtering techniques for tables. We’ll discuss some simple techniques that we can utilize when we have massive tables on our query.  For example, when we need to extract information from a database or an ERP system, it could have 10 million rows within

Continue reading

Column From Examples Power BI – Power Query Tutorial

Column-From-Examples-Power-BI-–-Power-Query-Tutorial

For today’s blog, I want to share my favorite feature inside the Power Query Editor, by far, which is the Column from Examples Power BI. You can watch the full video of this tutorial at the bottom of this blog. When I look at my data sets now, I always think about how I can

Continue reading

Power Apps Introduction: Definition, Features, Functions And Importance

Power-Apps-Introduction--Definition,-Features,-Functions-And-Importance

Microsoft Power Apps has quickly become a must-have tool not just for seasoned app creators, but for beginners who want to dabble in app creation as well. In this Power Apps introduction, I’m going to talk to you about what Power Apps is all about so that you can have a good idea as to

Continue reading

Power BI Data Transformation and Setting Up Models and Relationships

Power BI Data Transformation and Setting Up Models and Relationships

In this tutorial, I’m going to show you how I set up my models and the relationships in it. Creating a seamless flow around Power BI data transformation can greatly improve the report development process, and the way you set up your models is a primary contributor to this flow. To clearly portray my Power

Continue reading