If column lower than 8

[Raggsokk]

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 ? 🙂

[HotChilli · Accepted solution]

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.

[Raggsokk]

Yes that was easy, thank you 🙂