Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ? 🙂
Solved! Go to 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.
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.
Yes that was easy, thank you 🙂