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 @apolotakesh,

From the screenshot, there is relationship between Table_01 and Table4, what's the field used to relate the two tables? Do you mind share your .pbix file? You can share it by private message.

Best Regards,
Angelia

apolotakeshi's avatar
apolotakeshi
Frequent Visitor
8 years ago

the column is the D_O which has the values 1,2

that links with Table4.Value which also has 1,2

 

the thing is it only thinks as excel, and I needed it to be a little smarter ;/

like using a field to calculate a new column, or using things like SET analysis from Qlikview.

If i wanted to sort some information by 2 columns I can't get it done...

I think that programming in this language or the DAX Language is not one of the best in order to get things done ;/

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi apolotakeshi，

    I'm not specific about Qlikview, so I can't reproduce your requirement without sample table. I really hope you share it, and list expected result, so that we can post detailed workaround.

    Best Regards,
    Angelia