Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Raggsokk
Frequent Visitor

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

 

ServerNumber of Cores of CPUSPLA lisence number
Server11212
Server268

 

Anyone got time to show me how to do this ? 🙂

 

 

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

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.

View solution in original post

2 REPLIES 2
HotChilli
Super User
Super User

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 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors