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.
Good afternoon
I'm wanting to put together a column in my table to be able to separate the values that are return so then I can calculate the percentages of rejection of my logistics, in one of the columns I have that is called TYPE I have the values DEV (of return) and VEN (of sale) and another of AMOUNT that indicates the billing of that voucher. what I would need is that if the TYPE is DEV I return the value and if it is VEN I return value 0. I don't know if I explain myself correctly?
voucher | guy | Matter |
Invoice 1234 | DEV | $155 |
invoice 3934 | Come here | $189 |
invoice 948 | DEV | $1862 |
Solved! Go to Solution.
1. Right Click your Table, and select 'New Column'
2. Now you can use traditional IF THEN logic looking at each row (vs. Measures where this is harder)
Hope this helps...
Forrest
Proud to give back to the community!
Thank You!
1. Right Click your Table, and select 'New Column'
2. Now you can use traditional IF THEN logic looking at each row (vs. Measures where this is harder)
Hope this helps...
Forrest
Proud to give back to the community!
Thank You!
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |