Display last Quarter Date in the Date Select slicer

[ak77]

Hi all,

I have a date select slicer as below with only one selection at a time . i want to replcae this slicer to display only last day of the quarter like 30-09-2022,31-12-2022,31-03-2023 as in pic2. Please help if this option is possible

Pic 1:

Pic 2 

[vicky_ · Accepted solution]

If you want to use the last day in quarter, you can create calculated columns:

Quarter = QUARTER('calendar'[Date])

Last date in Quarter = CALCULATE(LASTDATE('calendar'[Date]), REMOVEFILTERS('calendar'[Date]))

I've separated the columns for readability, but you can modify the formulas to make it just 1 column.