Basheer24Frequent Visitor6 years agoSolvedPercentage Calc Hi all, I'm new to Power BI and need some advice regarding the below. Show MoreFowmy6 years agoBasheer24 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
Fowmy6 years agoBasheer24 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
Fowmy6 years agoBasheer24 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
FowmySuper User to Basheer246 years agoBasheer24 Glad it worked! Pleaee mark my reply as a solution and click on the Thumbs Up 👍 icon Thanks Fowmy
Related contentCalc not resulting in Percentage?!Percentage by groupExcel Calc in Power BICumulative Fiscal week DAX CalcDax Time Intelligence Functions Weird behavior - 13 Month Rolling Calc