Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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)
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
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)
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
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.
User | Count |
---|---|
4 | |
3 | |
2 | |
2 | |
2 |