Forum Discussion

thedatahiker's avatar
thedatahiker
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Calculate measure in source or in DAX Query

This is a general question that I'm trying to get a clear answer to. If you could provide any documentation that exist on this topic it would be super appreciated.   Is it more performant to calcul...
General Comment
joglidden2's avatar
joglidden2
Icon for Post Patron rankPost Patron
4 years ago

I personally prefer to assemble my solutions in SQL views. This is mostly because I'm more familiar and comfortable with SQL than I am with DAX. Also, PBI/DAX has "funny" behaviour and options that I'm still not quite used to. I generally see PBI/DAX to be the "quick & dirty", and SQL to be the reliable solution for the long haul, especially if you intend to re-use your views across multiple reports. It spares you from having to rewrite columns/measures every time. 0.02