Calculate Percentage of Two Columns in Power BI

How to calculate Percentages or Percentage of two columns in Power BI. With Power BI, we can calculate percentage of two columns or percentage between two numbers. Percentage Calculation in Power BI, helps to find accurate percentage of two columns. You will get more Power BI videos like this in Power BI Tutorial for Beginners series. @PettakaTechnologies
=============================================================
#tutorial #powerbi #PettakaTechnologies #daxfunctions #businessintelligence
=============================================================
This Power BI Calculate Percentage of Two Columns Tutorial video cover below topics:

1) How to Calculate Percentage of Two Columns in Power BI?
2) How to get Percentage of 2 columns in Power BI?
3) How to Calculate Percentage difference between two columns in Power BI?
4) How to do Percentage Calculation in Power BI?
=============================================================
- Learn Business Intelligence with Microsoft Power BI from Pettaka Technologies.
- Power BI Tutorial for Beginners 2023.
- Power BI by Pettaka Technologies.
- Data Cleaning with Power Query of Power BI
- Data Visualization with Microsoft Power BI.
=============================================================
For more awesome videos like this, visit our official YouTube channel
------------------------------------ PETTAKA TECHNOLOGIES --------------------------------------
=============================================================
To book slot for Power BI Online Training, visit our official Website
=============================================================

[tchand]

That was really helpful! Thank you so much!!

[andersonmacedo]

I have a question.
What if I want to aggregate the months in different ways. For instance, I want to filter by trimester. How can I have this percentage in a dynamic way so that I can have the percentage by trimester or semester etc

[smileymoviereview]

This is awesome tip. Thanks for sharing it ☺️

[DanielBerling-sd]

Hi. What what do I do in the following scenario?
My data table has millions rows
First columns "Carrier" - lists all carriers
Second Column: (Distinct) Count of Purchase Order, i.e. how many orders have been handled by that carrier
Third Column: Sum of Delayed Shipments (based on an indicator column that I added: when shipping days > value x, then 1 else 0: sum of sums up the 1s)

How do i show the values of the third column as percentage of the second?

[rksplashesdesignsbyrhondak]

got it. but, if you use that percent column in a table, the total is a sum of the % column. how can you make the total row be a division of the sum of each column?

[prasadsankpal]

Is there any way to calculate percentage of two rows
Like, Feb is how much percent of Jan