Forum Discussion
different outputs inside a calculated column using SWITCH()
hey, im not new to powerbi or dax at all but im trying to achive someting and for the love of god im trying but always failing the demand is: i have a table: (its distinct so we...
Whitewater100
Solution Sage
Solution SageHi:
If you were to have a more column type structure to your table, it could help. Using transpose you could reshape the data. Something like:
If all your rows were populated underneath the column headers similiar to this? Then it is much easier to set up dimension tables you want to filter on and for DAX to work easier.. Not sure if this is feasible, just a thought.