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
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi thedatahiker 

 

In my view, and many have their own, it should depend on several key factors, among others:

 

  1. How the data is structured
  2. Level of detail the data is available (e.g. transactional or summarised)
  3. Your / your client's requirement for the report (e.g. once-off or repeatability, etc)

I will always try to use measures where possible when creating financial / accounting indicators.  They are often cleaner and easier to work with as you start to piggyback from one measure to the next.  

 

Best of luck with it all!

Theo 🙂