Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power Bi - DAX - Sales Achievement

Hi All,
In my Data model I have monthly sales lets say till June 2023 , each month has a target but target added to all months event future months (till end of the year)
I need to calculate the Year to Date achievement by comparing the Sales of all months (from the beginning of the year till last sales month which is June) to the same months with Target (not the whole year)
i.e. 6 months sales to 6 months target

1 Reply