Target by fiscal month wrong calculation

[ahhollan]

My measure is returning an inaccurate target value by month. See screenshots below for details.

Relationships

Any help would be appreciated.

[v-yalanwu-msft]

Hi, @ahhollan ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @ahhollan ;

Maybe you can add Filter('table',[Date]=Max([Date])
The date here depends on the Date in your model.
Since you have many models, I can't reproduce it. If you can, can you share a simple file after removing sensitive information, and the desired output?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[davehus]

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

[ahhollan]

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

[davehus]

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.