YTD for last year

[#1]

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

[manideep78]

Could you please provide some samle data???

[alexandros17 · Accepted solution]

let vCurrWeek= week(today())

=Sum({<[Fiscal Year]={$(=Max([Fiscal Year])-1)},

Op_Week={'>=1<=$(vCurrWeek)'}

>}[Sales Amount GBP])

Hope it helps

[manideep78]

Try this

Sum({<[Fiscal Year]={"$(=Max([Fiscal Year])-1)"},Op_Week={">=1<=$(=Week(Today()))"}>}[Sales Amount GBP])

Hope it helps