Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
jbenson
Helper III
Helper III

Excel Formula

‎04-07-2022 01:15 PM

I am looking for a way to convert the below formula from excel to power bi on per week per row basis.

Is that possible? just wanting to stream line some manual excel work 

 

=ROUND(IF(C9>40,(((C9-40)*1.5)+40)*D9,D9*C9),2)

Labels:
Message 1 of 3
320 Views
0
1 ACCEPTED SOLUTION
bcdobbs
Super User
Super User

‎04-07-2022 02:33 PM

It looks like all the cells are on the same row?

 

  • Do you have a similar table imported in Power BI? If so a calculated column will do that for you. Syntax in this case is virtually identical.


Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

Message 2 of 3
277 Views
2 REPLIES 2
bcdobbs
Super User
Super User

‎04-07-2022 02:33 PM

It looks like all the cells are on the same row?

 

  • Do you have a similar table imported in Power BI? If so a calculated column will do that for you. Syntax in this case is virtually identical.


Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Message 2 of 3
278 Views
jbenson
Helper III
Helper III
In response to bcdobbs

‎04-10-2022 10:54 AM

That worked great! Thanks for your help!

Message 3 of 3
246 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

View All