Using ‘What-If’ Parameters in Power BI

What-If parameters are a really powerful feature to implement in your models for scenario analysis. Scenario analysis is immensely important from an analytical perspective in Power BI and ‘What-If’ parameters allow you to quickly implement tables and measures for this type of analytics. Once you select the What-If parameter icon, it opens a popup box

Continue reading

Complete Power BI & DAX Tutorial Released On Enterprise DNA TV

Many have been asking for an end to end demo to work through on Enterprise DNA TV around Power BI & DAX, so I’ve decided to release one. Now everyone can learn how to create these amazing reports and dashboards with their own data. View the tutorial here – Power BI beginner tutorial This tutorial

Continue reading

Optimizing Power BI Tables using Query Parameters

Query parameters are a really strong feature in Power BI. There are many places that you can implement filters in Power BI, but there are some occasions where it’s better to do this at the query level versus the report level. You might want to create filters at the query layer if you have massive

Continue reading

Update to Multiple Currencies Management in Power BI – Advanced DAX

There are so many occurrences in financial analysis where we need to integrate exchange rates. Now, I have actually shown an example of how to do this using the LOOKUPVALUE function in Power BI. There is one slight issue with the particular function I went through in the initial video that I didn’t realize at

Continue reading

Isolating Weekday or Weekend Results Using DAX in Power BI

Sometimes calculating averages per day in your Power BI reports isn’t actually enough. You might run into a scenario where you only actually sell during weekdays. You might be a retailer or a restaurant where you only sell in a specific period of days. Now, if you go and run an averaging pattern in Power

Continue reading