Dax Help

Hi Nihed ,

I suggest you to create a continuous date table by calendar/calendarauto function. I can see last day of quarter which is in date format in second screenshot date table. However I couldn't see date in your first data screenshot. Did you created a relationship between your date table and your data table? If there is an active relationship by [Quarter/Year] columns, I think your visual will show all values in 2022 Q2 when you select it in slicer. I am still confused about what kind of result you want. Could you share a sample file with me and show me a screenshot with the result you want? This will make me easier to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.