Hi,
I am looking to convert an Excel formula to a DAX formula to be used in my PowerPivot data model.
My data set lists a number of investors and their portfolios' allocation towards different stocks.
Unfortunately, it is formatted something like this: Stock 1/5%/500,25:Stock 2/10%/1000,50:Stock 3/85%/8004, with "Stock name / proportion / amount", where the amount is irrelevant.
Currently, my Excel solution is along the lines of the following and can be found in the table "Solution":
Converting each formula into DAX is simple (replacing the TEXT formula with the FORMAT formula). However, my problem is that I am not sure how to convert the column references to table "Type" into DAX.
I have tried with the ALL function, but without luck. So, the parts I need help fixing are the " 'Type'[Type] " parts (I have removed some of the extra code that has nothing to do with the issue):
I have previously been using a Power Query solution, but unfortunately the workbook has begun crashing occasionally due to the size of the real data sets and number of columns the PQ procedure runs through.
The sample workbook is attached here. Thanks!
Bookmarks