Category: Power BI

Using Multi-Layered Scenario Analysis in Power BI

I’m huge on scenario analysis in Power BI. Being able to input variables inside your calculations that you can ‘shock’ to effectively predict outcomes is so powerful when trying to make decisions. You may watch the full video of this tutorial at the bottom of this blog. In Power BI you can complete this really

Continue reading

Compare Cumulative Information Over Different Months In Power BI

Showcasing cumulative results in Power BI is such a powerful way to visualize your data over time, especially if you are trying to show the difference in performance from one time period to another. You may watch the full video of this tutorial at the bottom of this blog. When you try to present this

Continue reading

The DATEADD Function: The Best And Most Versatile Time Intelligence Function in Power BI

If you need a Power BI time intelligence function that you can use to generate time comparisons over a range of different time frames, then the DATEADD function is the one you’re looking for. You may watch the full video of this tutorial at the bottom of this blog. This, by far, is my go-to

Continue reading

How To Harvest Power BI Slicer Selections To Use Within Other Measures

How To Harvest Power BI Slicer Selections To Use Within Other Measures

What I’m looking to achieved here is to showcase how you can create a table on the fly in Power BI, then place a column of that table into a slicer to then extract or ‘harvest’ a value inside a measure. You may watch the full video of this tutorial at the bottom of this

Continue reading

First Ever Power BI & DAX Master Class Event From Enterprise DNA

Announcement--Power-BI-&-DAX-Master-Class

Next week, we will be running our first ever Power BI & DAX Master Class event. This will be a virtual event held on Enterprise DNA TV. This 4-day event is a new Power BI learning experience that we plan to put on every quarter. You can learn more about the workshop sessions and register

Continue reading