Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |