Forum Discussion
Generate table dynamically using slicer value
Hello, I was building a semantic model and ran into this issue. We daily holdings data and are required to show data for last 2 years. For each date the requirement is that user should be able to...
Hi MFelix,
I basically ended up using EVALUATE and running a paginated report from the model. This way i didnt have to store all the decomposed information in the model.
Basically what the percentage was that lets say if i am invested into a fund for $100 and the fund's MV is $1000 then i basically hold $100/$1000 = 1% of the fund hence decomposing the value will show every security that the Fund holds with a calculated MV of 1%