Forum Discussion
replace a date value with blank
Hi All,
I have a date column and want to show "1/1/1900" as blank in table/Matrix view.
How should is acheive this?
| Date |
| 1/1/1900 |
| 4/1/2022 |
| 3/1/2022 |
| 6/6/2022 |
| 6/1/2022 |
| 4/1/2021 |
| 6/20/2022 |
| 5/23/2022 |
regards,
Gopi
1 Reply
Gopinath_iyer
Create Calculate
Date Blank =
IF ( 'Table X'[Date] = MIN ( 'Table X'[Date] ), BLANK (), 'Table X'[Date] )
Gopinath_iyer if this post helps you so please mark as solutions.THANK YOU!!
