Tag: What If Parameters

Power BI Parameters Via Query Editor

Creating And Using Parameter

In this tutorial, we’ll discuss how we can create and use Power BI Parameters which is a powerful feature of the Query Editor.  There are instances when we want to put additional filters on our data within the query editor. We can do that by utilizing the Manage Parameters option within the Home ribbon. For this

Continue reading

Power BI What If Parameter For Data Models

Scenario tables 'what if' parameters

This article will briefly talk about integrating scenarios into our models. We can do that by using the Power BI  What If Parameter feature. We can add this parameter to our reports as slicers or reference them on DAX expressions. Integrating a What If Parameter into our reports enables us to create scenarios or predictive

Continue reading

First N Business Days Revisited – A DAX Coding Language Solution

Let’s take another look at the problem discussed in this tutorial, which dynamically compared the first N business days of each month. This problem was based on a query from an Enterprise DNA member on our forum, where he wanted to dynamically look and compare the first 5, 10, 15, and 20 billable days (the

Continue reading

Dynamic Segmentation With Dynamic Parameters – Advanced Power BI & DAX Technique

Dynamic Segmentation With Dynamic Parameters - Advanced Power BI & DAX Technique

I’m going to talk about dynamic segmentation using dynamic parameters because I’ve seen members ask about it so many times on the Enterprise DNA support forum. You may watch the full video of this tutorial at the bottom of this blog. What’s challenging about this is figuring out which areas to segment first. You would

Continue reading

Using Advanced DAX For Multiple IF Statement In Power BI

In this article, I’m going to give you a tutorial about utilizing multiple IF statements in Power BI. This short tutorial is from a specific thread in the Enterprise DNA Support Forum. You may watch the full video of this tutorial at the bottom of this blog. In the Enterprise DNA Support Forum, members ask

Continue reading