Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using the following expression
if(H1='Previous Completed Quarter', Sum({<Quarters={$(=Concat(Distinct Quarters-1,','))} ,[Accounting Period]={$(=Concat(Distinct [Accounting Period]-3,','))}>}[Service Rev]),
if(H1='Recent Completed Quarter',sum({$}[Service Rev]))
))
where h1 is the header and quarters are fetched from accounting period as follows.
quarters accounting period
1 1,2,3
2 4,5,6
3 7,8,9
Problem is data is showing correctly for quarter>1 , but for quarter 1 no data is being shown.
Hi,
Can you share sample data file.