Will there be a difference in size of the file if we create custom columns in power query rather than calculated column in dax
Hi @Anu, did the response provided by @AntrikshSharma help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!
Hi @Anu,
As Microsoft states:
The DAX calculated column does not compress as well as the other methods. The other column types do get compressed, which makes the .pbix file smaller and the performance usually faster.
But as @AntrikshSharma already mentioned - you could do a quick test to see the differences because will depend on your data.
You could also use the Dax Studio tool to see more details like Model Metrics and check which other table/columns take space.
Hi @Anu, we’ve noticed that no response has been received from you since the 11th of April. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @Anu, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.
We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!