Time Intelligence with Slicer for Next QTD and remaining of the month of the year

[CuriousGuy001]

Hi everyone,

I am trying to build a slicer using a table to make it simplicity to filter out for the next quarter instead of showing the current QTD, for example when you click on "QTD" I want to display it for Quarter 3 from July to September. I am trying to use NextQuarter formula but it return an error ,

This is my relationship model,

Also, if possible to make a Dax calculation for the remaining of the months of the year, instead of CTRL + Click selecting from July to December, and simplify it with one slicer,

[v-jialongy-msft]

Hi @CuriousGuy001 

Maybe you can try the following dax:

Qtd Table = 
CALENDAR (
    DATE ( YEAR ( TODAY () ), QUARTER ( TODAY () ) * 3 + 1, 1 ),
    DATE ( YEAR ( TODAY () ), QUARTER ( TODAY () ) * 3 + 3, IF (
        QUARTER ( TODAY () ) * 3 + 3 = 6||9,
        30,
        31
    ) )
)

Result:

Best Regards,

Jayleny

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

[CuriousGuy001]

Hi Jayleny,

I tried that DAX calculation, it seems it didn't work for me. What I am trying to do is to make 1 slicer for QTD/ROY, ROY (remaining of the year) when the user click in the QTD, it narrows the next Q3 which is July - September of the Forecast 2024 table with its 4 category ( Leads Forecast, Booked Forecast, Run Forecast, Closing Forecast) that I am posting below this.