New Functions – GENERATESERIES, SELECTEDVALUE
In the August 2017 update of Power BI Desktop Microsoft released the new What If feature (first demonstrated at MDIS in July). This new What If capability uses two new DAX functions to complete a task that you have always been able to do manually. You still can of course still do it manually, but now it is easier than ever as the new functions make the task of creating a disconnected table/slicer very easy indeed. I am not actually sure if these 2 new functions were created in order to make the What If process easier or if that was a co-incidence. Regardless, let me explain the new underlying DAX functions and how they work so you can use these without the What If button if you choose.
Both of the new functions are currently only available in Power BI (to my knowledge). I know for sure they are not currently available in Excel.
Tags: dax