Forum Discussion
Solved
DAX Formula Help
Hello, I am compare last years actual spend to this years actual spend. So I'd like to take FY24 - FY23. I was able to accomplish something similiar by using this DAX: FY24 Actual vs. FY24 B...
Try removing the year column from the table visual. The year column breaks the months into two parts, i.e., in Sept 2022 the FY24 is 0, and Sept 2023 FY23 is blank.
Thank you! I should have thought of that lol.