Excluding future quarters

[Emma1]

Hi guys,

i have this script

[ Date.AutoCalendar.Quarter]&' : '& aggr(num(count(distinct [Amount])/count(total{<{ Date.AutoCalendar.Quarter]}>}
distinct [Amount]),'#,##0.00%'),
[Date.AutoCalendar.Quarter]))

It return the Amount for each quarter but for future quarters, it show zeros. How can i exclude any quarter that is still in future and return only past and present ones

[Wlad_Masi]

Hi @Emma1 where are you using this expression you provided us?
Quarters are in your auto calendar table, you may have to add to your expression a logic that respect your expression if quarter is equal or smaller actual quarter.

[dwforest]

Change your calendar to not extend to dates in the future,

[Emma1]

I am using this on a pie chart such that when you rotate the pie each slice shows data and percentage with needing to hover