Forum Discussion
PercentRank below a fixed value
Hello, I'm looking for a formula that will allow me to identify the % turnaround times for a CT Scan that are below a fixed time such as 120 minutes. Percentrank.inc(array, 120) works in excel. ...
Hi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
Here is the data. Normally there are 30k+ rows. The percent.rank.inc for the below data is 86.3%
% rank under 2 hours (120 min) 0.863 Formula =PERCENTRANK.INC(B7:B221,120,3)
The next issue is the real reason I am trying to use Powerbi. I need to be able to calculate this number by month using a filter in bi. I can do it in excel, but would rather be able to simply add the next month's data to my table.
TAT minutes 124 124 123 123 123 122 122 122 122 122 122 122 122 121 121 121 121 121 121 121 120 120 120 120 120 120 120 120 120 120 119 119 119 119 119 119 119 119 119 119 118 118 118 118 118 118 118 118 118 118 118 118 117 117 117 117 116 116 116 116 116 116 116 116 116 116 115 115 115 115 115 114 114 114 114 114 114 114 114 114 113 113 113 113 113 113 113 113 113 113 113 112 112 112 112 112 112 112 112 112 112 112 112 112 112 112 112 112 112 111 111 111 111 111 111 111 111 111 110 110 110 110 110 110 110 110 110 110 110 110 109 109 109 109 109 109 109 109 109 109 108 108 108 108 108 108 108 108 108 108 108 107 107 107 107 107 107 107 107 107 107 107 106 106 106 106 106 106 106 106 106 106 106 106 106 106 106 106 105 105 105 105 105 105 105 105 105 105 105 105 105 105 105 105 104 104 104 104 103 103 103 103 103 103 103 103 103 103 103 103 103 103 102 102 I just typed this in Google - percentrankinc function in powerbi.
Could you check on your own
