How to filter Deal for Closing Date > then Today ?

[admin11]

Hi All

I have create an expression to filter Closing Date > today no error but not working :-

_Show Closng Date > Today = IF ('CRM_TS'[Closing Date] >= Year(TODAY()), 1, 0)

I exprected it should filter only first 2 row :-

My PBI file :-

https://www.dropbox.com/s/66k9xoeg01es79j/CRM_TDS_V023%20asking%20ONLY%20few%20sample%20filter%20mor...

Paul

[amitchandak · Accepted solution]

@admin11 , create like

_Show Closng Date > Today = IF ('CRM_TS'[Closing Date] >= TODAY(), 1, 0)

_Show Closng Date > Today = IF (year('CRM_TS'[Closing Date]) >= Year(TODAY()), 1, 0)