Tag: DAX Functions

How To Use SWITCH True Logic In Power BI

When utilizing SWITCH/True Logic inside Power BI, you really do open up this huge expanse of analytical opportunities. In this tutorial, I’ll run through 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 within Power BI. There

Continue reading

Getting Started With The “What If” Parameter In Power BI

The possibilities of using the What If parameter in Power BI is deemed endless. It gives users and businesses the flexibility to design a solution for the critical answers and insights that they need. In the recent Enterprise DNA learning summit, we had a successful session regarding the usage and implementation of What If Parameter

Continue reading

Check Out Our Re-Imagined DAX Formula Reference Guide

We’ve been working on a huge project at Enterprise DNA. We’ve deeply thought about and then re-imagined how you could create a better DAX formula guide.  And we have finally completed it and ready to release it to all those connected to Enterprise DNA.  You can find the DAX guide within our Knowledge Base. Please check out the link below to navigate straight to it.  DAX Reference Guide

Continue reading

Using Moving Averages To Show Trends in Power BI

In this blog post, I want to dive into trend analysis. Specifically, how to highlight trends in Power BI really effectively using moving averages. The concepts that I go through here are techniques you might have already touched on yourself in the past. But I wanted to show how important it is from a visualization perspective

Continue reading

Iterating Functions In DAX Language – A Detailed Example

For this blog post, I want to dive into iterating functions within the DAX language in Power BI. The reason why I want to spend some time showing what you can do inside of iterating functions is because it’s such an important concept that you need to learn very well. You might have only just

Continue reading