tusharsharma24
New Member
- Joined
- Sep 3, 2018
- Messages
- 4
I have the following data set for which I need to divide into decile for a particular year and also want to view the banks in a particular deciles. Is It possible to create this on the basis of a calculated column in Power BI. I used a simple Decile formula, but that doesn't work.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Bank_Name | Loans/ Deposits (%) | Year |
Bank of America Corp. | 75.67 | 2017Y |
Bank of America Corp. | 75.01 | 2016Y |
Bank of America Corp. | 77.57 | 2015Y |
Bank of America Corp. | 81.77 | 2014Y |
Bank of America Corp. | 86.45 | 2013Y |
Bank of America Corp. | 87.46 | 2012Y |
Bank of America Corp. | 93.61 | 2011Y |
Bank of America Corp. | 98.08 | 2010Y |
Bank of America Corp. | 96.72 | 2009Y |
Bank of America Corp. | 108.65 | 2008Y |
Bank of America Corp. | 112.67 | 2007Y |
Bank of America Corp. | 104.27 | 2006Y |
Bank of America Corp. | 92.27 | 2005Y |
Bank of America Corp. | 85.46 | 2004Y |
Bank of America Corp. | 91.84 | 2003Y |
Bank of America Corp. | 92.24 | 2002Y |
Bank of America Corp. | 90.35 | 2001Y |
Bank of America Corp. | 108.89 | 2000Y |
JPMorgan Chase & Co. | 66.26 | 2017Y |
JPMorgan Chase & Co. | 66.33 | 2016Y |
JPMorgan Chase & Co. | 66.48 | 2015Y |
JPMorgan Chase & Co. | 57.67 | 2014Y |
JPMorgan Chase & Co. | 59.41 | 2013Y |
JPMorgan Chase & Co. | 63.56 | 2012Y |
JPMorgan Chase & Co. | 65.82 | 2011Y |
JPMorgan Chase & Co. | 78.13 | 2010Y |
JPMorgan Chase & Co. | 69.36 | 2009Y |
JPMorgan Chase & Co. | 75.42 | 2008Y |
JPMorgan Chase & Co. | 75 | 2007Y |
JPMorgan Chase & Co. | 74.45 | 2006Y |
JPMorgan Chase & Co. | 80.88 | 2005Y |
JPMorgan Chase & Co. | 83.2 | 2004Y |
JPMorgan Chase & Co. | 67.24 | 2003Y |
JPMorgan Chase & Co. | 70.96 | 2002Y |
JPMorgan Chase & Co. | 74.03 | 2001Y |
JPMorgan Chase & Co. | 77.34 | 2000Y |
Wells Fargo & Company | 72.8 | 2017Y |
Wells Fargo & Company | 75.69 | 2016Y |
Wells Fargo & Company | 76.16 | 2015Y |
Wells Fargo & Company | 75.13 | 2014Y |
Wells Fargo & Company | 77.81 | 2013Y |
Wells Fargo & Company | 83.92 | 2012Y |
Wells Fargo & Company | 89.02 | 2011Y |
Wells Fargo & Company | 95.64 | 2010Y |
Wells Fargo & Company | 100.24 | 2009Y |
Wells Fargo & Company | 113.52 | 2008Y |
Wells Fargo & Company | 118.01 | 2007Y |
Wells Fargo & Company | 113.87 | 2006Y |
Wells Fargo & Company | 111.94 | 2005Y |
Wells Fargo & Company | 118.62 | 2004Y |
Wells Fargo & Company | 117 | 2003Y |
Wells Fargo & Company | 117.3 | 2002Y |
Wells Fargo & Company | 110.88 | 2001Y |
Wells Fargo & Company | 104.52 | 2000Y |
U.S. Bancorp | 81.63 | 2017Y |
U.S. Bancorp | 82.86 | 2016Y |
U.S. Bancorp | 87.55 | 2015Y |
U.S. Bancorp | 88.94 | 2014Y |
U.S. Bancorp | 90.38 | 2013Y |
U.S. Bancorp | 92.31 | 2012Y |
U.S. Bancorp | 92.89 | 2011Y |
U.S. Bancorp | 99.04 | 2010Y |
U.S. Bancorp | 108.89 | 2009Y |
U.S. Bancorp | 118.08 | 2008Y |
U.S. Bancorp | 120.69 | 2007Y |
U.S. Bancorp | 117.59 | 2006Y |
U.S. Bancorp | 111.85 | 2005Y |
U.S. Bancorp | 105.81 | 2004Y |
U.S. Bancorp | 100.52 | 2003Y |
U.S. Bancorp | 104.22 | 2002Y |
U.S. Bancorp | 111.41 | 2001Y |
U.S. Bancorp | 129.73 | 2000Y |
PNC Financial Services Group, Inc. | 84.14 | 2017Y |
PNC Financial Services Group, Inc. | 82.93 | 2016Y |
PNC Financial Services Group, Inc. | 83.62 | 2015Y |
PNC Financial Services Group, Inc. | 89.16 | 2014Y |
PNC Financial Services Group, Inc. | 89.56 | 2013Y |
PNC Financial Services Group, Inc. | 88.93 | 2012Y |
PNC Financial Services Group, Inc. | 86.18 | 2011Y |
PNC Financial Services Group, Inc. | 84.02 | 2010Y |
PNC Financial Services Group, Inc. | 85.62 | 2009Y |
<colgroup><col><col><col></colgroup><tbody>
</tbody>