topic Adding a + infront of a value and 0 in place of blank in a measure in DAX Commands and Tips

Adding a + infront of a value and 0 in place of blank in a measure

Coffee2023 — Thu, 20 Jun 2024 19:54:19 GMT

Hello community,

I am trying to figure out how to put a + infront of my delta values and replace blanks with a 0. See below my current measure & table. When I hit enter it populates but gets rid of all my other information like last name..ext. and there are only 0s in the pages delta column. What am I missing? Thank you for your help in advance!

Pages Delta = Var Delta = Calculate(SUMX('All Programs DE', 'All Programs DE'[Pages Entered]), FILTER('All Programs DE', 'All Programs DE'[Date Difference] < 8)) return "+" & If(ISBLANK(Delta), 0, Delta)

Re: Adding a + infront of a value and 0 in place of blank in a measure

Anonymous — Fri, 21 Jun 2024 01:37:38 GMT

Hi Coffee2023 ,

You can try this. After using the format function to format Delta, use the CONCATENATE function to concatenate the two text strings into one text string.

Pages Delta = VAR Delta = CALCULATE( SUMX('All Programs DE', 'All Programs DE'[Pages Entered]), FILTER( 'All Programs DE', 'All Programs DE'[Date Difference] < 8 ) ) RETURN IF( ISBLANK(Delta), "0", CONCATENATE("+", FORMAT(Delta, "0")) )

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Adding a + infront of a value and 0 in place of blank in a measure

Anonymous — Wed, 26 Jun 2024 07:01:56 GMT

Hi Coffee2023 ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.