Forum Discussion

ahhollan's avatar
ahhollan
Icon for Helper I rankHelper I
4 years ago

Target by fiscal month wrong calculation

My measure is returning an inaccurate target value by month. See screenshots below for details.   Relationships Any help would be appreciated.
Need Help
davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

Hi ahhollan , you have no date relationship between target and date table.

ahhollan's avatar
ahhollan
Icon for Helper I rankHelper I
4 years ago

I created the relationship and the numbers are better, but not correct. See screenshots.

 

 

 

 

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    4 years ago

    Hi ahhollan , it all comes back to the granularity of your data. If they are at different granularties or the joins aren't correct within the model, then you won't get the desired outcome. I don't full understand your model, all I can suggest is taking it back to a single row of the desired outcome and troubleshooting from there.