Skip to main content

Power BI

New

Ability to create a dynamic column

Vote (2) Share
John Yip's profile image

John Yip on 24 Dec 2021 01:22:53

It will be a great functionality if developers can create a column whose values change according to the slicer selection, as we can keep our DAX clean and easy to maintain when we create measures in which the calculations are done using columns based on the slicer value. If we can create a dynamic column, we can just , in our MEASURES, refer to that column in the DAX without defining a lot of logic to cater to different scenarios. This way, we can keep our DAX DRY and easy to maintain.

Comments (3)
John Yip's profile image Profile Picture

John Yip on 24 Dec 2021 01:24:44

RE: Ability to create a dynamic column

https://community.powerbi.com/t5/Desktop/Cloning-an-entire-column-based-on-the-value-of-a-measure-single/m-p/2253201

John Yip's profile image Profile Picture

John Yip on 24 Dec 2021 01:24:36

RE: Ability to create a dynamic column

https://community.powerbi.com/t5/Desktop/Create-a-dynamic-column-based-on-slicer-selection/td-p/459849

John Yip's profile image Profile Picture

John Yip on 24 Dec 2021 01:24:07

RE: Ability to create a dynamic column

This function is wanted, as it has been discussed.
https://community.powerbi.com/t5/Desktop/Create-a-dynamic-column-based-on-slicer-selection/td-p/459849
https://community.powerbi.com/t5/Desktop/Cloning-an-entire-column-based-on-the-value-of-a-measure-single/m-p/2253201