find the largest value from two columns by category/row in Power BI desktop

[Anonymous]

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

[Shahfaisal · Accepted solution]

IF( [sales forecast] > [sales quantity], [sales forecast], [sales quantity] )

Is this what you are looking for?

[Anonymous]

YES!! thats perfect thank you