hi all....i have created fileds using below expression but is not showing the values(measures) is there any thing that i still have to add on the expression?
YTD - LYTD
if(if(Month(date(Floor(Date)))<=3,(Year(date(Floor(Date)))-1)&'-'&(Year(date(Floor(Date)))),(Year(date(Floor(Date))))&'-'&(Year(date(Floor(Date)))+1))=if(Month(((today())))<=3,(Year(((today())))-1)&'-'&(Year(((today())))),(Year(((today()))))&'-'&(Year(((today())))+1)),1,0) as YTD_Flag,
inyeartodate(Date, $(vDateToday), -1,4)* -1 AS LastYTDFlag
