Hi All,
This expr get the values of previous financial year
=if(Count({<SalesFY={$(=max(SalesFY)-1)},ITEM={'GOLD'},fYear=>}[MASTER REFERENCE CATEGORY CODE])>0,count(distinct {<SalesFY={$(=max(SalesFY)-1)},ITEM={'GOLD'},fYear=>}BILLDATE))
But all i need is 'Previous FY's counting of days' that mean if i select 2 days it'll be shown 2, and 3 for 3 and so on. Ho do i do this for
date, help me out guys