Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
M_nwadibia
Resolver III
Resolver III

expression to Replace a blank date with current DATE in ssrs

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_0-1672073269735.png

 

2 ACCEPTED SOLUTIONS

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)

M_nwadibia_0-1672769916983.png

M_nwadibia_1-1672769986838.png

 

 

View solution in original post

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

View solution in original post

6 REPLIES 6
TOK
Helper II
Helper II

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

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)

M_nwadibia_0-1672769916983.png

M_nwadibia_1-1672769986838.png

 

 

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
Resolver I
Resolver I

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.

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

Ah sorry I thought it was Power BI.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.