The dataset has every single date from early 2017 through now (late 2019), the goal is to create a calculated field to indicate the last day of each month of all years in the dataset. The calculation that I have so far returns the last day of the most recent 12 months, but it is missing the months from the other years. What do I need to change?
Create a Calendar Table and build a relationship from the Date column of the base data table to the Date column of the Calendar Table. In the Calendar Table, create a column for Year and Month. Build a matrix visual and drag Year and Month there. Write this measure