Forum Discussion
Freezing data/ removing a dax formula
Hello,
Does anyone know if it is possible to freeze data/ remove a dax formula from a column so that the numbers stay but they are now not related to another column anymore? Or maybe create a similar column without the formula and the relation?
4 Replies
Hello,
Is there any way to freeze data in a column or remove the dax-formula so that the numbers stay the same, without the previous relation to another column? Or create a duplicate of the column without it having a formula?
Can you provide an example?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I have this column. What I wish is to create a similar column with the same data but without the "Related" formula, so that I have the same column of numbers but it doesnt relate to another column. Is this possible?
So, you could go into your model and right click the table and choose "Copy Table". You could then paste this into an Enter Data query, remove all of your columns except the one you want and a unique id. Then you could use a DAX join to merge these tables back together, NATURALINNERJOIN function. Something along those lines.
