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.HTML Code:
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.HTML Code:
The sample workbook is attached here. Thanks!
Bookmarks