How can I calculate -
How many months (Current Year) had > sales then Last Year. If you look at the image and you can see that 8 Months were > greater than, 4 Months were less.
Thanks in advance.
Matt
Hello @mbraun,
Thank You for posting your query onto the Forum.
It’s always a bit difficult for the Forum members to provide assistance without looking at the PBIX file. While posting a query please ensure that PBIX file is attached so that members can assist you in a better and efficient manner without which it involves guessing work and consumes their time.
In order to achieve the results based on the scenario that you’ve mentioned. Below is the screenshot attached alongwith the PBIX file provided for the reference purposes.
Hoping you find this useful and meets your requirements that you’ve been looking for.
Important Note: In case the provided solution doesn’t meets the requirements then attach either a working or demo PBIX file so that further assistance can be provided.
Thanks and Warm Regards,
Harsh
No. of Months - Sales TY More Than LY - Harsh.pbix (76.7 KB)
1 Like