Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Hi @Anonymous
It seems you may use 'Unpivot columns' for table B.Then link the two tables.
Regards,
Cherie
Hi @Anonymous
It seems you may use 'Unpivot columns' for table B.Then link the two tables.
Regards,
Cherie
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |