Forum Discussion
Solved
How to Return These Values
Hi Experts
I posted this question earlier and was thinking that I got the answer but it is not working. I have these 2 columns A and B. I have Calculated these values (NOT IN POWER QUERY) but using IF Statements by adding Custom Column. Here A and B are Integars. I want exact following display for A/B as TEXT, no Division. I want the values of A/B.
| Category | A | B | A/B |
| 7865315 | 4 | 0 | 4/0 |
| 7865335 | 1 | 0 | 1/0 |
| 7865336 | 3 | 0 | 3/0 |
| 7865351 | 0 | 0 | 0/0 |
| 7865453 | 3 | 0 | 3/0 |
| 7865588 | 1 | 1 | 1/1 |
| 7865737 | 0 | 0 | 0/0 |
Thanks
Deepak
HI drrai66
I think I understand what you are after and the following calculated column works for me.
A/B = 'Table3'[A] & "/" & 'Table3'[B]
1 Reply
HI drrai66
I think I understand what you are after and the following calculated column works for me.
A/B = 'Table3'[A] & "/" & 'Table3'[B]