Hi,
I am facing a situation, where I need conditional values to be displayed as dimension.
For example, My expression is like
=PICK(vDashboard,if(([F1.autoCalendar.Date]>=YearStart(today(1),-1)),[F1.autoCalendar.YearMonth],''),if(([F2.autoCalendar.Date]>=YearStart(today(1),-1)),[F2.autoCalendar.YearMonth],''),if(([F3.autoCalendar.Date]>=YearStart(today(1),-1)),[F3.autoCalendar.YearMonth],''),if(([F4.autoCalendar.Date]>=YearStart(today(1),-1)),[F4.autoCalendar.YearMonth],''))
Here, my requirement is , display
yearMonth(F1) as dimension if date(F1) is greater than or equal to previous year's last date when vDashboard=1
yearMonth(F2) as dimension if date(F2) is greater than or equal to previous year's last date when vDashboard=2
yearMonth(F3) as dimension if date(F3) is greater than or equal to previous year's last date when vDashboard=3
yearMonth(F4) as dimension if date(F4) is greater than or equal to previous year's last date when vDashboard=4
My Problem is, dimension doesn't change when my vDashboard value changes.
Is there a better way of replicating this requirment or is there any syntax issues. Please help!
Regards,
Sasikala