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
