Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to concatenate 3 text columns into one column, separated by a semi colon, in query editor which sounds simple, but I am only getting null values?
I am trying to concatenate the three soft credit fields in the picture below. THanks in advance for your help!
Solved! Go to Solution.
hello @danielrsnyder, I had the same results.
Try Text.Combine. Edit - of course that is assuming you do not have number in store credit.
= Table.AddColumn(#"Added Custom", "Text.Combine", each Text.Combine({[SoftCredit],[Soft Credit_1],[Soft Credit_2]},"; "))
Proud to be a Super User!
hello @danielrsnyder, I had the same results.
Try Text.Combine. Edit - of course that is assuming you do not have number in store credit.
= Table.AddColumn(#"Added Custom", "Text.Combine", each Text.Combine({[SoftCredit],[Soft Credit_1],[Soft Credit_2]},"; "))
Proud to be a Super User!
Hmm, that's strange as that looks like the right syntax.
I just did a nested if outside of the query editor and that works, but would have been a lot easier in the editor it seems.
Soft Credit = IF(not ISBLANK('Gifts Last Week'[Soft Credit_2]),'Gifts Last Week'[SoftCredit] & "; " & 'Gifts Last Week'[Soft Credit_1] & "; " & 'Gifts Last Week'[Soft Credit_2],if(AND('Gifts Last Week'[Soft Credit_2]=BLANK(),not ISBLANK('Gifts Last Week'[Soft Credit_1])),'Gifts Last Week'[SoftCredit] & "; " & 'Gifts Last Week'[Soft Credit_1],'Gifts Last Week'[SoftCredit]))
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |