I have two tables in my model (Date & Source file). Source file holds daily values. My issue is that year 1 in source file holds a single value per calendar month, however, year 2 holds a single value each day of the calendar month.
So when I compare Q1Y1 vs Q1Y2 my total sum shows £91 vs £2839, and it should be £91 vs £63. This is due to summing the values in each day.
Is there a way of summing only the last day of the month to get the expected values?
Attached sample file
Test.pbix (80.2 KB)