Forum Discussion
Solved
Converting a rank/count/value apportionment formula from Excel to BI
I have a formula in Excel which takes a total cost value and apportions it against various grades, which are ranked. The quantity of a particular ranking can vary by month and by factor (shown here ...
Cleary I need more coffee ryan_mayu as I was creating a measure. I switched it to a column and got a result, albeit a strange one so I think I'm still not going the right way.
I'm not sure I understand the request re the excel file. Data as shown:
As formulas: