topic Re: Adding text when formula calculates blank in DAX Commands and Tips

Adding text when formula calculates blank

Nick221_ — Tue, 21 Feb 2023 21:03:58 GMT

I have the below formula that is calculating the last blank value and pulling it into this new table. My question is it easily possible to add another part of this formula to insert the phrase "Not submitted" if the formula is pulling a blank value.

Re: Adding text when formula calculates blank

olgad — Tue, 21 Feb 2023 21:22:16 GMT

Hi,
before your formula place If( your whole formula=blank(), "Not submitted", yourfromula)

or to make things cleaner use variable:
Completed=
var vCompleted= your formula
If( vCompleted=blank(), "Not submitted", vCompleted)

Re: Adding text when formula calculates blank

Nick221_ — Tue, 21 Feb 2023 21:36:52 GMT

That worked! Thank you so much!

Re: Adding text when formula calculates blank

olgad — Tue, 21 Feb 2023 21:55:43 GMT

Please kudo and accept as a solution, thank you!