Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Just when I start thinking I'm getting a grasp on using PowerBI I run into another stupid problem that stumps me.
I have a table full of end dates for projects. Some of them however are blank.
If I wanted a column to show the blank dates AND those dates whose end date has already passed what would be formula?
I played with it for a while and got this but it isn't working.
Date2 = if (PROJECTS[ENDDATE] = blank() || TODAY() < PROJECTS[ENDDATE]), PROJECTS[ENDDATE])
As always thanks for your help.
Solved! Go to Solution.
In your scenario, you want create a column to display the EndDate which is blank or earlier than current day. Right?
To achieve your requirement, you can try following expression:
Column = IF ( OR ( PROJECTS[ENDDATE] = BLANK (), TODAY () > PROJECTS[ENDDATE] ), PROJECTS[ENDDATE] )
Thanks,
Xi Jin.
In your scenario, you want create a column to display the EndDate which is blank or earlier than current day. Right?
To achieve your requirement, you can try following expression:
Column = IF ( OR ( PROJECTS[ENDDATE] = BLANK (), TODAY () > PROJECTS[ENDDATE] ), PROJECTS[ENDDATE] )
Thanks,
Xi Jin.
User | Count |
---|---|
94 | |
79 | |
76 | |
65 | |
60 |
User | Count |
---|---|
108 | |
101 | |
77 | |
63 | |
61 |