How to calculate Q1 2021 and previous year 2020 Q1

[Subba55]

Spoiler

Spoiler

Hi guys ,

I want to show Q1 2021 and Q1 2020  count(request id) in KPI, How to write expression.

Please help me,

Thanks in advance.

Regards,

Subba Reddy

[Vegar]

Assuming you have date field, named [Date]. Try this.

Count({<[Date]={">=quarterstart('2021-01-01')<=quarterend('2021-01-01')"}>}RequestID)

This expression is assuming you have YYYY-MM-DD as default Date format, if  not then you should adjust to your format.

You can adjust the hard codes dates with an dollar expansion or variable.