Forum Discussion

CSpina's avatar
CSpina
Icon for Helper III rankHelper III
6 years ago
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,...
Need Help
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

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))

 

CSpina's avatar
CSpina
Icon for Helper III rankHelper III
6 years ago
ANO1970197119721973197419751976
1970320.670318.265311.852303.033299.025295.177293.413
1971 412.121409.030400.788389.454384.303379.357
1972  474.343470.785461.299448.254442.325
1973   571.193566.909555.485539.777
1974    655.140650.226637.124
1975     674.633669.573
1976      705.136

 

I want to get  ANO 1970 column 1976

  • CSpina's avatar
    CSpina
    Icon for Helper III rankHelper III
    6 years ago
    ANO1970197119721973197419751976
    1970320.670318.265311.852303.033299.025295.177293.413
    1971 412.121409.030400.788389.454384.303379.357
    1972  474.343470.785461.299448.254442.325
    1973   571.193566.909555.485539.777
    1974    655.140650.226637.124
    1975     674.633669.573
    1976      705.136