I want to find the difference in sales between months but till the day of today. I wrote the measures below. Sales_till_day measure works. But when I want to find percentage differences, it doesn’t work, however, any error doesn't appear.
Thanks for your reply @Mariusz. This is just for one month. With the DAX you wrote I have to write a formula for 12 months. I need each month until the current day. For example, Today is the 21st of June. I need to see the sales till January 21, February 21, March 21 and so on. And the percentage comparison between June and other months. For example, June sales are 23% higher than January, 3% lower than February, etc.