Hi, Don't want to use a Dax formula in my calculations if i want to use my date table multiple times. Could you add the Role playing dimensions to SSAS tabular like this is possible with a SSAS SSAS Multidimensional Cube.
3 Comments
- You can create a calculated table based on your initial dimension.
- calculated tables still need a lot of configuring. all properties - Format strings, calculated columns etc are not copied, it only copies the raw partition columns. There is a solution here and something with less boiler plate code would be better https://martinschoombee.com/2020/06/24/a-user-friendly-way-to-deal-with-role-playing-dimensions-in-power-bi/ Potentially could use Calculation Groups to extend this idea however it means that we would end up with one calculation group per table that needed it which would extend the cube complexity for end users. Better to build something in as a first class citizen.
- Status added:Needs Votes
