banding

Hi This is my excel file I am trying to put a band automatically in column W but it is not happening What I need is that if an Employee salary is >= 15000 but less than 20000 then he/she be in Band "I" similarly in increments of 5000 till band "XV" However the above formula is sending an...

Hello, I’ve been searching for an answer for this for 2 days and cannot find a solution or I am not able to understand one if I see it. I’m new to DAX. I’m trying to create an end product of a Powerpivot report showing sales by: Product Category, Product Number, Product Sales Price, Sales...

Hi forum, I am working on a employee performance report. Usually the employee task complexity divided to three major categories like Easy, Average and Hard. For every complexity we give banding based on accuracy limits as per below table. Now I need to map this to my main fact table column...

Hi, Looking for a method for taking a percentage and 'banding' it. Percentage bands are as follows. 1 15 - 25%2 25 -38 %3 38 - 50%4 50 - 56%5 56 - 65%6 65 - 70%7 70 - 81%8 81 - 87.5%9 87.5 - 100%Their raw score is entered in column IThis shows a percentage score in column JHow do I get column K...

Hi guys I have a various level pricing format as below, which should work similar to scaled commission / tax calculations. For example, 15000 units, should be charged as the first 5k (£0), the next 5k (£3 per unit) and the remaining 5k units charged at £2.50 per unit. I've done some research...

Hi all, Wondering if anyone could help. I have a column of data with values ranging from 0- 30+ I would like to know the number of values between 5-10, 10.1-15, 15.1-20, 20.1-25, 25.1-30, >30 is the are 'countif' statement or something i can produce to find this? It would be incredibly...

On occasion when I export to Excel from a specific program I receive the export with banding that I do not want. How can I remove this banding? I am running Excel 2013

Hello Mr. Excel, I have been searching on multiple occasions for a solution to my highlighting needs. At one point and time I found a guide that showed me how to highlight all rows that had the same cell value, then when the cell value changed it would alternate the shading. It used a MOD...