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.
Hi All,
I have 2 WHOLE NUMBER COLUMN LIKE A and B. I want To Create another TEXT COLUMN Like THIS: A/B
So if
A B A/B
1 3 1/3
4 6 4/6
A/B should return TEXT VALUE as above
Thanks
Deepak
Solved! Go to Solution.
Hi @drrai66
I would go into the Power Query Editor, then click on Add Column in the Ribbon.
Then click on Custom Column and put in the following code below.
NOTE: This will work as long as your columns A and B are set to a data type of Whole Number
Text.From([A]) & "/" & Text.From([B])
Which then has the following result.
Hi @drrai66,
You can use below dax formula to achieve the desired result.
A/B = Data[A] & "/" & Data[B]
Thanks,
Rahul
Hi @drrai66,
You can use below dax formula to achieve the desired result.
A/B = Data[A] & "/" & Data[B]
Thanks,
Rahul
Hi @drrai66
I would go into the Power Query Editor, then click on Add Column in the Ribbon.
Then click on Custom Column and put in the following code below.
NOTE: This will work as long as your columns A and B are set to a data type of Whole Number
Text.From([A]) & "/" & Text.From([B])
Which then has the following result.
Worked Perfectly!!!
Actually you showed me a way. I did like this
Column =[A] & "/" & [B]
Thnaks
Deepak
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |