Forum Discussion

ldamato's avatar
ldamato
Frequent Visitor
4 years ago

Small Multiples Sum Wrong Values

Hi all,    I'm using small multiples to create a chart that gets the running sum of each broker I have.  To do the running sum, I use this formula (which works great):  Measure = CALCULATE(SUM(S...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

The use of date hierarchies is discouraged. Use a proper calendar table in your data model.

ldamato's avatar
ldamato
Frequent Visitor
4 years ago

Hi lbendlin 
I tried to create a calendar table, but did not manage to use the drill down function (which I need). Without a date hierarchy I couldn't see only month and year without the day, but with the possibility to drill down to days if I need. 

 

Thanks,
Leo