Forum Discussion
Solved
If column lower than 8
Hello
I'm new to Power BI, and I'm trying to automate the correct number of Windows Server lisences we need.
My report has a list of Cores, I would like to add a new column [Number of Cores of CPU], I would like to make a new Column [SPLA lisence number] that is the same as [Number of Cores of CPU] if the number is higher then 7, but the number should never be lower then 8
| Server | Number of Cores of CPU | SPLA lisence number |
| Server1 | 12 | 12 |
| Server2 | 6 | 8 |
Anyone got time to show me how to do this ? 🙂
Add a custom column : you will use a 'if.. then.. else' statement.
and the algorithm will be "if the column is less than 8 then 8 else the column"
I encourage you to get in there and try it.
