Tag: Power BI Tutorial

Deep Dive Into The TREATAS Function – Virtual Relationships For Power BI

In this example, I dive into one of the most advanced DAX functions in Power BI┬ácalled TREATAS. If you can understand TREATAS, you’ll see that it has so many applications for you across all reports and dashboards which you might be creating inside of Power BI desktop. TREATAS will helps greatly in the simplification of

Continue reading

Creating Dynamic Ranking Tables Using RANKX In Power BI

I really like using this unique technique inside of Power BI to create dynamic ranking tables. What do I mean by Dynamic Ranking Tables? Dynamic tables showcase a range of information dynamically in a table, but the information that are showing are based off a specific ranking on a singular calculation. In this particular example,

Continue reading

Understanding How The AVERAGEX Function Works

In this example, we’ll dive deep into the AVERAGEX function. This is a truly powerful function that can be used in so many different ways. It can very efficiently calculate interesting results very quickly. You need to truly understand how this works and what’s happening behind the scenes. That’s what this tutorial is focussed on.

Continue reading

SWITCH True Logic Explained For Power BI

When utilizing SWITCH/True Logic inside of Power BI you really do open up this huge expanse of analytical opportunities. In this tutorial, I will run through in detail how you need to set up your formulas when using the SWITCH function. This will enable you to find, discover, and visualize many different and interesting insights

Continue reading

How To Use The CROSSJOIN Function – Power BI & DAX Tutorial

CROSSJOIN is a really effective function that you can utilize inside of Power BI to essentially bind two tables of data together. It’s not just about selecting any two tables from your data sets. What you can do is actually also manipulate tables inside of the CROSSJOIN function so they can be joined in a

Continue reading