Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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).
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.