Tag: What If Parameter

Scenario Analysis Techniques Using Multiple ‘What If’ Parameters

Power BI is an incredible tool to run scenario analysis and what-if analysis examples. I’ve actually never seen or come across an analytical tool that is as effective and intuitive to implement this type of complex analytics. The key is that you’ve got to think more analytically about the underlying elements in your datasets than

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. Then be able to insert this into an existing calculation or another measure that

Continue reading