Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.