expression to Replace a blank date with current DATE in ssrs

[M_nwadibia]

Hello,

I have this weekly report I distribute every monday. I find situations where dates are blank as displayed below and all data is displayed in the previous week bar. I need an expression to replace the blank date with current date so that I can have the fourth bar instead of 3 bars as shown below. Your suggestions will be appreciated.

[M_nwadibia · Accepted solution]

Hello,

I tried implementing this  but I get this error below . How can I clear the error?

iif(Fields!WeekStart.Value = Blank(), Today(), Fields!WeekStart.Value)

[TOK]

Hi M_nwadibia,

this should work: =iif(Fields!Date.Value = Blank(), Today(), Fields!Date.Value)

Liked this post? More Content on:
https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ

[M_nwadibia · Accepted solution]

Hello,

I tried implementing this  but I get this error below . How can I clear the error?

iif(Fields!WeekStart.Value = Blank(), Today(), Fields!WeekStart.Value)

[TOK · Accepted solution]

Hi @M_nwadibia,

sorry, my fault. Blank doesn't work in ReportBuilder.
Please try the following:

=iif(cstr(Fields!WeekStart.Value) = "", Today(), Fields!WeekStart.Value)

Liked this post? More Content on:
https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ

[ouaelaam]

You can create a simple calculated date column with a formula like below :

Date_Adjusted =
IF ( ISBLANK ( 'Table'[Date] ), TODAY (), 'Table'[Date] )

✔️

If this post is helpful, please consider marking it as a solution so that other users may find it more easily.

[M_nwadibia]

Oh I did not mention that this is SSRS expression and not power Bi. Thanks

[ouaelaam]

Ah sorry I thought it was Power BI.