Forum Discussion
tvaishnav
4 years agoHelper IV
How do model data with different granularity?
I have a situation where I want to compare cost and revenue. My revenue number is just an aggregate, however cost has sub categories. How would you model this? I can think of these ways. 1) P...
johnt75
4 years agoSuper User
Have a read of https://www.daxpatterns.com/budget/ by the SQLBI guys, it should give you some ideas about working at different granularities.