Include YTD into a measure

[thomas_2583]

Hi, 

I have the following calculation below which gives me the value for the full financial year. 

sum({<[com_dt_FY]={'FY19/20'},  prod_dt_FY ={'FY19/20'}>}total_sales) 

com_dt_FY is derived from com_dt (DD/MM/YYYY)

prod_dt_FY is derived from prod_dt (DD/MM/YYYY)

How can I amend my calculation to show only the YTD value please? Do I need to include the original date variables com_dt and prod_dt ?

[Gabriel · Accepted solution]

Hi,

If you have a calendar script, I will advise you create a Flag in your calendar for YtD. And if you don't have a calendar table use script below

IF(INYEARTODATE(YourDateFieldName,TODAY(),0),1,0) AS [%Flag_InYtD]