Forum Discussion
Helper ITarget 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.
5 Replies
ahhollanI created the relationship and the numbers are better, but not correct. See screenshots.
davehusMemorable Member
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.
- v-yalanwu-msft
Community Support
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. - 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.