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.
You do not need to ask for help on forums if you already know the correct answer. 🤷♂️
I have come here, because i do not know the solution. I am stuck at a junction where one type of filter will allow one set of slicers to work and other will allow different set. I am trying to find middle ground between those 2 filters . The community has always helped me in tough times. Thanks for cooperation
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