Use column in another table with no relationship

[Anonymous]

Hello,

I have two tables, let's call them Table A and Table B:

Table A looks like:

Year     Percentile
2018     x
2019     x
2020     x

Table B looks like:

2018     2019     2020
x              x            x
x              x            x
x              x            x

Basiclly, in table A I need to use a colunm function that uses the percentile DAX function, which only allows colunms. I've tried PERCENTILE.INC(B[Year]) but that doesnt work because it can't find year. Is there a better way I can do this?

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

It seems you may use 'Unpivot columns' for table B.Then link the two tables.

Regards,

Cherie