How to get Quarterly data using measure expression

abc_18 — Sat, 16 Nov 2024 18:18:15 GMT

Hi,

I have a filter called Fyear, which contains data from April 2018 to June 2020 and financial year starts from April.

In a bar chart, I need to display quarterly data , I am using quarter expression as below:-

Count({$<[Date]={">$(=QuarterStart(Max([Date]),-3)))<=$(=Quarterend(addmonths(Max([Date]),-9)))"}>}(score)) ( Gives 4,5,6 Months)

Count({$<[Date]={">$(=QuarterStart(Max([Date]),-2)))<=$(=Quarterend(addmonths(Max([Date]),-6)))"}>}(score)) (Gives 7,8,9 Months)

Count({$<[Date]={">$(=QuarterStart(Max([Date]),-1)))<=$(=Quarterend(addmonths(Max([Date]),-3)))"}>}(score)) (Gives 10,11,12 Months)

Count({$<[Date]={">$(=QuarterStart(Max([Date]),0,4)))<=$(=Quarterend(addmonths(Max([Date]),0)))"}>}(score)) (Gives 1,2,3 Months)

Above expression is working fine for FY18,FY19, but for FY20, I am facing issues as FY 20 is not yet closed. for Q1 I am getting (10,11,12) months data of 2019, as it;s subtracting from the available data set.

for Q1 , it should dispaly (4,5,6) months data of 2020, as for FY 20 I have data available till June month.

Regards

topic How to get Quarterly data using measure expression in App Development

How to get Quarterly data using measure expression