Forum Discussion
Finding Latest Fiscal Date in Column
ABR002 What have you tried? What are the side effects?
From my testing, it seems like you could just use MAX(Table[Date]) and set the format string on the measure to MMMM YYYY.
ABR002 What have you tried? What are the side effects?
From my testing, it seems like you could just use MAX(Table[Date]) and set the format string on the measure to MMMM YYYY.
For some reason it always gives me December 2021 when I do that. I can't figure out why. The latest date is July 2021, but it gets more complicated (then I originally mentioned) as the months aren't calendar months, so April 1 might actually be in March.
What I ended up doing is creating a conditional column that sends the fiscal years date back a year if the month is less than or equal to 6, combine the year and month, and then filter that by max.
