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
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
Sorry for sounding rude. I will try your suggestions and come back with more updates. Thank you for your reply. AntrikshSharma