Forum Discussion
Solved
Measure based on the selected year from calender table
Hi I need help to create a "Target" measure based on the year selected in visual. I have a calender table and provided slicer for year selection alone. Based on the selected year my report ch...
Hi,
Try this measure
=IF(HASONEVALUE(Calendar[Year]),IF(VALUES(Calendar[Year])=2017,30000,20000),BLANK())
Hope this helps.
Hi,
Try this measure
=IF(HASONEVALUE(Calendar[Year]),IF(VALUES(Calendar[Year])=2017,30000,20000),BLANK())
Hope this helps.