Forum Discussion

Frequent Visitor

6 years ago

Solved

Percentage Calc

Hi all,

I'm new to Power BI and need some advice regarding the below.

Fowmy
6 years ago
Basheer24

If you need to match with Excel formula, modify the formula as, ADD 1-

Percentage = 1-DIVIDE( OSS, TOTAL DURATION,1)

________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
YouTube, LinkedIn

3 Replies

Fowmy
Super User
6 years ago
Basheer24

If you need to match with Excel formula, modify the formula as, ADD 1-

Percentage = 1-DIVIDE( OSS, TOTAL DURATION,1)

________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
YouTube, LinkedIn
- Basheer24
  Frequent Visitor
  6 years ago
  Thanks Fowmy. It's working now.
  - Fowmy
    Super User
    6 years ago
    Basheer24
    
    Glad it worked!
    
    Pleaee mark my reply as a solution and click on the Thumbs Up 👍 icon
    
    Thanks
    Fowmy

Related content