Forum Discussion
DAX Union with SelectColumns
Hi,
This is the result that i get. It matches with yours. I further need to check it for whether it will work with filter/slicers or not. So share the filters/slicers you will be applying on this visual and your expected results with those filters/slicers.
That is great news. Thank you Ashish.
This is just a preliminary report, I haven't gotten very far in finalizing anything. The relationships between the tables are below:
ReturnData is my combined table, TimeDim is my custom date table. Valuations and Cashflows are structured similarily to the data I sent prior. The Securities table contains the security id and the name of the security (sorry that I can't provide actual information to you).
The filters on the combined ReturnData table are super simple. There is a report level filter that utilzes the TimeDim table's Date field.
Users are able to select a time period and one or multiple securities, if multiple securities are selected, the combined table should contain all cashflows for the securities, plus an aggregated beginning and ending nav. If you could post the custom table formula I could add it to my model and let you know how it performs with my data.
Thanks again
~AK_BA