Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |