Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am struggling to find a solution to show me YTD values for the last fiscal year and was hoping that someone could help..
My current expression is ..
=Sum({<[Fiscal Year]={$(=Max([Fiscal Year])-1)}>}[Sales Amount GBP])
that just gives me the total sales for the last fiscal year, i want it to look at this years current week number but apply that to the set analysis to show from week 1 to the current week last year.. if that makes sense..
my week field is :
Op_Week
Can anyone help?
Many thanks
let vCurrWeek= week(today())
=Sum({<[Fiscal Year]={$(=Max([Fiscal Year])-1)},
Op_Week={'>=1<=$(vCurrWeek)'}
>}[Sales Amount GBP])
Hope it helps
Could you please provide some samle data???
let vCurrWeek= week(today())
=Sum({<[Fiscal Year]={$(=Max([Fiscal Year])-1)},
Op_Week={'>=1<=$(vCurrWeek)'}
>}[Sales Amount GBP])
Hope it helps
Try this
Sum({<[Fiscal Year]={"$(=Max([Fiscal Year])-1)"},Op_Week={">=1<=$(=Week(Today()))"}>}[Sales Amount GBP])
Hope it helps