Forum Discussion
Solved
How do I get value form column x row
My be a silly question, but is my mind How do I get a value from column and row? I have tried using a measure below: Measure = CALCULATE(SUM(fEMPL_AUT[Valor]),FILTER(fEMPL_AUT,...
| ANO | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 |
| 1970 | 320.670 | 318.265 | 311.852 | 303.033 | 299.025 | 295.177 | 293.413 |
| 1971 | 412.121 | 409.030 | 400.788 | 389.454 | 384.303 | 379.357 | |
| 1972 | 474.343 | 470.785 | 461.299 | 448.254 | 442.325 | ||
| 1973 | 571.193 | 566.909 | 555.485 | 539.777 | |||
| 1974 | 655.140 | 650.226 | 637.124 | ||||
| 1975 | 674.633 | 669.573 | |||||
| 1976 | 705.136 |
I want to get ANO 1970 column 1976
| ANO | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 |
| 1970 | 320.670 | 318.265 | 311.852 | 303.033 | 299.025 | 295.177 | 293.413 |
| 1971 | 412.121 | 409.030 | 400.788 | 389.454 | 384.303 | 379.357 | |
| 1972 | 474.343 | 470.785 | 461.299 | 448.254 | 442.325 | ||
| 1973 | 571.193 | 566.909 | 555.485 | 539.777 | |||
| 1974 | 655.140 | 650.226 | 637.124 | ||||
| 1975 | 674.633 | 669.573 | |||||
| 1976 | 705.136 |