Forum Discussion
GeorgeColl
Helper II
Helper IIBest practice for adding a field to model
I am looking to rebuild a previous model that I have been working on for a while and would like to improve the performance, tidy it up and generally do things in a more 'Correct' manner. Therefor...
sanalytics
Super User
Super UserGeorgeColl
Below is the thumb rule of creating any robust, optimized data model.
Data should be transformed as far upstream as possible, and as far downstream as necessary.
it is Roche's Maxim Data transformation law..
it simply says that if you think you can create any conditional column or measure calculation into the source. then Please go ahead.DO NOT HESITATE.
in you case, if you think you can do the calculation in Power query level, please do that.On the other hand, if you think the you can create the calculation in the SQL level rather than Power query level..Please do that..
trust me, it will make your life eaiser.
Bonus Tip : User Query folding.
Hope this will help you.
Regards,
sanalytics
GeorgeCollThat's excellent thanks