My table has a column called 'ETA Date'. It is a 'Date' dimension. Additional to different dates, it also has (No Value) and (Null), as in the screenshot below.

I want to replace (No Value) and (Null) with 'blank'. So, I tried to create a 'Calculated Dimension'.
But in the IF statement, I am not able to select the 'ETA Date' dimension. But all other NVARCHAR dimensions are available. So, is it correct to say that we cannot use an IF statement for a 'Date' dimension? or is there any other way to achieve the result?

The report is an optimized story.
Thank you,
Sarath Sunny
Request clarification before answering.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.