Forum Discussion

powerbi_user1's avatar
powerbi_user1
Frequent Visitor
8 years ago

Create a dynamic column based on slicer selection

I have two tables:   Table 1 ColumnA ColumnB A1 B1 A2 B2 A3 B3   Table 2 Column Types ColumnA ColumnB   I have a slicer for Columns Types and based on selection...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

powerbi_user1,


A bit change to Greg_Deckler's DAX.

ColumnC Measure = 
SWITCH(
     MAX('Table 2'[Column Types]),
     "ColumnA",MAX('Table 1'[ColumnA]),
     "ColumnB",MAX('Table 1'[ColumnB]),
     BLANK()
)



Regards,
Lydia