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,...
Hi CSpina ,
can you provide sample data?
With date columns you can try the following.
Measure =
CALCULATE(SUM(fEMPL_AUT[Valor]),FILTER(fEMPL_AUT,fEMPL_AUT[Linha].[Year]=1975&& fEMPL_AUT[Coluna].[Year] = 1975))
| 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