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 am reasonably new to power bi and was hoping for some help creating a new column (with dax) to find the largest value per category/row from two columns.
Below is an example of my data now. The two columns I want to compare to find the largest value per Category/row is Sales forecast and sales quantity.
Item Code. | sales forecast. | sales quantity. |
a | 20 | 30 |
b | 10 | 5 |
c | 50 | 60 |
d | 80 | 70 |
e | 5 | 10 |
Below is what I would like my table to look like
item code. | sales forecast. | sales quantity. | Required Stock Level. |
a | 20 | 30 | 30 |
b | 10 | 5 | 10 |
c | 50 | 60 | 60 |
d | 80 | 70 | 80 |
e | 5 | 10 | 10 |
If anyone can help that would be very much appreciated.
Thank you
Solved! Go to Solution.
IF( [sales forecast] > [sales quantity], [sales forecast], [sales quantity] )
Is this what you are looking for?
IF( [sales forecast] > [sales quantity], [sales forecast], [sales quantity] )
Is this what you are looking for?
YES!! thats perfect 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 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |