Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |