Forum Discussion

BachFel's avatar
BachFel
Icon for Helper II rankHelper II
8 years ago
Solved

Calculate, sum? need help with a formula

Following problem: in the table LN[Leistungsbeschreibung] can be more than one row with the text "Objektbegehung", per ID. i.E.:   ID          Leistungsbeschreibung       Datum  111        Objek...
Need Help
  • Floriankx's avatar
    Floriankx
    8 years ago

    Hello,

     

    I used ID instead of KostElementID, might be a little confusing because you have several IDs

     

    FILTER(LN;LN[KostElementID]=EARLIER(KontElement[KostElementID]) hopefully works now.

BachFel's avatar
BachFel
Icon for Helper II rankHelper II
8 years ago

Hello,

 

I wrote

 

FILTER(LN;KontElement[ID]=EARLIER(KontElement[ID])

instead of

FILTER(LN;LN[ID]=EARLIER(KontElement[ID])

 

 

because in the table LN there is now column with the expression you took.

 

 

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi BachFel,

 

Please no noticed that generally EARLIER() function is used in a calculated column, not a measure.

 

Thanks,
Xi Jin.