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
Based on your description, it sounds like you have a single table. You should create a star schema. Here are some articles I wrote on the topic.
https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/
https://exceleratorbi.com.au/dax-time-intelligence-beginners/
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.
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
