Forum Discussion

Nihed's avatar
Nihed
Icon for Helper III rankHelper III
4 years ago

Help dax

Hello,   how can I grieve only the date on yellow by YTD-1 Thank you.
Nihed's avatar
Nihed
Icon for Helper III rankHelper III
4 years ago

I want just display "YTD N-1" in the column has the place of the date which is in yellow (2021)

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Nihed ,

 

Please try:

Col = IF(Year('Table'[Response Date]) = 2021,"YTD N-1",'Table'[Response Date])


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.