Last Date Incorrect Value

[cwilson]

I am struggling to get the last, latest, max date to calculate anything other than 11/1/2022. I changed the Date column to Date Type Locale. Nothing I seem to do will alter that 11/1/2022 return value. It should show 9/30/2023 I believe. 

[Idrissshatila]

Hello @cwilson ,

try the following 

LastDate = CALCULATE(LASTDATE(NASSPoultry[Date]), ALL(NASSPoultry[Date]))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[AmiraBedh]

Can you share your pbix file ?