Set Analysis YeartoDate question

[siri_v]

Hello, all,

I have this YTD calculation for metric Sum({$<FiscalYear={$(=Max(Year(Saledate)))}>}Sales)

This works great for current month.. But it does not work when I select Calendar filter (To and From dates) to Feb.. It gives MTD number..  Instead I would need from year beginning till max month selected..  

I have declared in load editor Num(Month(SalesDate)) as MonthNum,

I also tried giving this YTD calc : 

Sum({<FiscalYear={$(=Max(Year(Salesdate)))},MonthNum={"<=$(max(MonthNum)+1)"}>}Sales) but this does not work..

Can someone help me how to proceed. 

[Quy_Nguyen · Accepted solution]

Hi,

Try this one: Sum({<SalesDate ={">=$(=YearStart(Max(SalesDate)))<=$(=Date(Max(SalesDate)))"}>}Sales)

It will return YTD Sales of the max Sales Date 

[siri_v]

Thank you very much @Quy_Nguyen . This solution worked perfectly!