Date range selection for KPI chart

[Dr_T]

How do you make a fixed date selection in for KPI chart, for instance from 2021-01-01 to 2021-03-01?

Next how do you do it dynamically for to date values for instance?

Thanks

[MayilVahanan]

H @Dr_T 

Try like below

For Hard code:

=Sum({<Date={">=2020-01-01 <= 2021-03-01"}>}Yourexpression)

For Dynamic:

Its depends on your requirement, for ex: Sales per current year

=Sum({<Date={">=$(=YearStart(Max(Date))) <= $(=Date(Max(Date),'YYYY-MM-DD'))"}>}Sales)