Forum Discussion
Measure formula problem
He tried to help you, reading theory is paramount in DAX/PBI. At minimum you need to have 2 separate tables (Sales and dates) here then only DAX will work otherwise DAX has a concept of "auto exists" it won't let your code return what you want unless you switch to star schema.
Even after that you would need a disconnected dates table because if you filter 2024 you can't just return dates of 2023, so you need a slicer that has year column from disconnected dates table that doesn't filter the visual directly, instead it is filtered based on the DAX code.
Here are 2 example of that disconnected dates table: https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Previous-6th-month-max-date-sales/m-p/3981439#M154386
(select 2017 & 2018 from filters pane and then select any month from first quarter of 2018)
https://www.youtube.com/watch?v=A0h_0kf-0oI&ab_channel=AntrikshSharma
That case is not possible. I am doing internship in a comapny. I have to manage this data in its current way.
Then as an intern the first thing you learn and do today is to push back on bad data model and make them adapt the star schema.