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)

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hi:

Can you try this.

 

Replace = IF(Dates[Date] <= DATE(2021,12,31), SUBSTITUTE(Dates[Date], Dates[Date], "LYYTD"))