remove delimiter if combinevalues empty

Question

I have a large COMBINEVALUES doing combination of Ifs...but when there results all return false, it returns "" for the ifs, so the combinevalues resutls returns the delimiter only.&nbsp; How do I not return the delimiter for empty values without repeating all the ifs over again?

parry2k · Answer

Anonymous please share sample data with expected output.
&nbsp;
Read this post to get your answer quickly. https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

anonymous · Answer

Hey&nbsp;Anonymous&nbsp;It would help if you put the current DAX you are using.In general, you can wrap an IF statement arround your DAX.e.g.IF(YOUR_DAX = "YOUR_DELIMITER", BLANK(), YOUR_DAX)&nbsp;Good Luck!A

anonymous · Answer

Yeah, the reason i didn't is because it's really long.

It's basically Switch(condition,

IF statement,

IF statement with combinevalues(", ", if statement, if statement, if statement, if statement, if statement, if statement)

IF statement,

)

If all those if statements inside combinevalues return as false (false condition returning ""), then combinevalues returns ",,,," as the result. Which is correct, but I don't want those delimiters? i want it to return "". And I don't want to have to repaste the if statements and make it twice as long suddenly.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;Try the folllowing and add an IF statmentIF(combinevalues(", ", if statement,&nbsp;if statement,&nbsp;if statement,&nbsp;if statement,&nbsp;if statement,&nbsp;if statement) =&nbsp;",,,,",
BLANK(),&nbsp;combinevalues(", ", if statement,&nbsp;if statement,&nbsp;if statement,&nbsp;if statement,&nbsp;if statement,&nbsp;if statement))This will put a blank insted of&nbsp;",,,,".You can replace the BLANK() with "" if needed, for an empty string/text.&nbsp;Good Luck!A

anonymous · Answer

Thanks AClerk, I get that, the thing is I want to specifically not do it that way because doesn't it then need to process twice?&nbsp; When hitting a bunch of records, that seems like I'm doubling my resource usage.&nbsp;Isn't there a method of testing the result afterwards, like if(result = ",,,", "", result) ?

Forum Discussion

remove delimiter if combinevalues empty

5 Replies

Related content

Date remove delimiter

Remove delimiter and specific number of caracters before that delimiter

Escape row delimiter within quotes

decompress, skip lines, delimit

PowerQuery: remove text string between custom delimiters