Hi
I having daywise sales datablase. If I 3 month report how can i get how many month having above last yr sales.
i got 2017 sales table from Sum17:=calculate(sum([SALES]),SUMMARIZE(SALES,SALES[MONTH]),SALES[YEAR]=2017)
and 2016 sales table from Sum16:=calculate([sum([SALES]),SUMMARIZE(SALES,SALES[MONTH]),SALES[YEAR]=2016)
this is ok
how to count no of months above LY, tried this AboveLY:=countrows([Sum17]>=[Sum16]) returns error
I having daywise sales datablase. If I 3 month report how can i get how many month having above last yr sales.
i got 2017 sales table from Sum17:=calculate(sum([SALES]),SUMMARIZE(SALES,SALES[MONTH]),SALES[YEAR]=2017)
and 2016 sales table from Sum16:=calculate([sum([SALES]),SUMMARIZE(SALES,SALES[MONTH]),SALES[YEAR]=2016)
this is ok
how to count no of months above LY, tried this AboveLY:=countrows([Sum17]>=[Sum16]) returns error