Forum Discussion
ahhollan
Helper I
4 years agoTarget 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.
v-yalanwu-msft
Community Support
4 years agoHi, 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.