Forum Discussion

apolotakeshi's avatar
apolotakeshi
Frequent Visitor
8 years ago

Using switch to dinamically create a dimension (need list not values)

Hi all I have a Table4 in which I select the value that I want, it is either 1 or 2. if it is 1, i want the column to show the values that exists in Table_01 column Dbase17, else I want them to retu...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi apolotakeshi,

Please create a calculated column using the formula below in Table4.

Dinamic_Column =
if(Table4[Value]="1"
;RELATED(Table_01[Dbase17])
;RELATED(Table_02[Dbase16])
)


We assume the column including either1 or 2 named as "column1". Then create a table visual, select the Table4[column1] and Dinamic_Column as value level. Create a slicer including Table4[column1], the visual will change as you select different value in slicer.

Best Regards,
Angelia

CerbPBI's avatar
CerbPBI
Frequent Visitor
4 years ago

Related works if there is one to many relationship. From table 4 to table1 , you have many to one.

create the above calculated column on table 1 instead.

 

Dynamic_Column =
if(Trelaed(table4[Value])="1"
;Dbase17
;Dbase16)
)