Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I used combinedvalues as shown.
I want to trim the space in order to get numbers instead of text.
I couldn't do it in power query because the column is not showing. Is there other ways to combine the values not as text.
Thanks
Solved! Go to Solution.
Hi @djurecicK2 ,Thanks for your quick reply, I will add more.
Hi @tksnota ,
You can use the following DAX expression to create a column.
Column3 = IF(ISBLANK([Column2]),[Column1],[Column2])
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
The convert function works. But my other issue now is how to merge the data into one column as shown in the table view without using power query
Hi @djurecicK2 ,Thanks for your quick reply, I will add more.
Hi @tksnota ,
You can use the following DAX expression to create a column.
Column3 = IF(ISBLANK([Column2]),[Column1],[Column2])
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tksnota ,
The combinevalues function is expecting text fields. You can use the CONVERT function on numeric fields within the combinevalues function to change numeric fields into text fields. Like CONVERT(textfield, DOUBLE).
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
32 | |
26 | |
24 | |
19 | |
16 |
User | Count |
---|---|
52 | |
38 | |
24 | |
24 | |
20 |