Need Help with calculating % of a value in a column

[eguechi09x]

Hello, I could really use a little help figuring this out.

I have a column with 4 possible values current, current 30 Days, Future 30 Days, and Past Due. I would like to figure out how to calculate what percent of Past Due I have in a column.

Than you

 

[Momentman]

Hello, I could really use a little help figuring this out.

I have a column with 4 possible values current, current 30 Days, Future 30 Days, and Past Due. I would like to figure out how to calculate what percent of Past Due I have in a column.

Than you

Book1
	B	C	D	E
1	Status			% of Total count
2	Current 30 Days		Past due	26%
3	Future 30 Days
4	Future 30 Days
5	Past due
6	Current
7	Current
8	Future 30 Days
9	Current
10	Current 30 Days
11	Future 30 Days
12	Past due
13	Future 30 Days
14	Current
15	Past due
16	Past due
17	Current 30 Days
18	Past due
19	Current
20	Current
Sheet1

Cell Formulas
Range	Formula
E2	E2	=COUNTIF($B$2:$B$20,D2)/COUNTA($B$2:$B$20)

 

[eguechi09x]

Book1
	B	C	D	E
1	Status			% of Total count
2	Current 30 Days		Past due	26%
3	Future 30 Days
4	Future 30 Days
5	Past due
6	Current
7	Current
8	Future 30 Days
9	Current
10	Current 30 Days
11	Future 30 Days
12	Past due
13	Future 30 Days
14	Current
15	Past due
16	Past due
17	Current 30 Days
18	Past due
19	Current
20	Current
Sheet1

Cell Formulas
Range	Formula
E2	E2	=COUNTIF($B$2:$B$20,D2)/COUNTA($B$2:$B$20)

Hi Momentman and this can be added/done in power query ? Sorry very new to all of this.