Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My below LYTD expression
num(sum({<Month,Year,YearMonth,date ={">=$(vLastYearStart) <=$(vLastYear)"}>}Sales) ,'##0.0')
It will give data will may-21 .Even if I select jun-22
Similarly for YTD
num(sum({<Month,Year,YearMonth,date ={">=$(vYearStart) <=$(vMaxDate)"}>}Sales) ,'##0.0')
It will give data will may-22 .Even if I select jun-22
But if I put space before below bold it will give all month data ir-respective of selection
num(sum({<Month,Year,YearMonth,date ={">=$(vYearStart) <= $(vMaxDate)"}>}Sales) ,'##0.0')
How about this.
YTD
Sum({$<[Date] = {'>=$(=YearStart(Today()))'}>} [Sales])
YTD Previous Year
Sum({$<[Date] = {'>=$(=Date(AddYears(YearStart(Today()),-1)))<$(=Date(AddYears(Today(),-1)))'}>} [Sales])
This is also give same result.Not working at all.
Could you perhaps clarify this?
" But if I put space before below bold it will give all month data ir-respective of selection ..."