Forum Discussion
Solved
Data modelling - from source or DAX
Hi all, New to BI - trying to work out best approach for the following scenario. My main metrics table in report includes metrics such as: Pick travel time - it uses a date time stamp t...
Hi clay_75 ,
Regarding your question, if your dataset is large. Then creating SQL views, i.e. preprocessing at the data source, is beneficial for performance.Also this is handy if you want to use the same calculation logic in multiple reports.Other than that, I'd use DAX because it's more flexible.
Hi clay_75 ,
Regarding your question, if your dataset is large. Then creating SQL views, i.e. preprocessing at the data source, is beneficial for performance.Also this is handy if you want to use the same calculation logic in multiple reports.Other than that, I'd use DAX because it's more flexible.