Forum Discussion
DAX Expression to return last year's value
I need to create a measure that returns a value for the same month as the current month, except it's last years value. I have a YearMonthSort column in my table 202302 --> The year 2023, Feb 20...
bolfri
Solution Sage
Solution SageIt's works like this because somewere on the page you have a filter on you fact data for column yearmonthsort. Thats why this measure "don't see" any other values from that columns. Do you consider using calendar as it should be? 🙂 You can believe me that working with calendar is SO MUCH EASIER for development.
- Oh I'll check that out! What do you mean "Calander as it should be"? I'd like to do things correctly!
- bolfri
Can you share some sample records (YearMonthSort columns & some value columns). Other columns not needed. 🙂