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
ldamato's avatar
ldamato
Frequent Visitor
4 years ago

Hi lbendlin , 

 

Thanks for the reply. I tested it and it's pretty much what I need. The only issue is that I couldn't make it work using Date Hierarchy, only with the full date value. Is there anything I can do to make this work? 

 

Thanks a lot

Leo 

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