Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

summing qty using two different columns

  Hi everyone . i need help . I need to sum the qty of vehicles of each quotation, but only for the first revision .  i marked in blue those ones that need to sum, the earliest revision of each quo...
wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
5 years ago

SUMX(VALUES(Planilha1[QuotationID]),VAR _c=Planilha1[QuotationID] RETURN MAXX(TOPN(1,FILTER(Planilha1,Planilha1[QuotationID]=_c),Planilha1[Revision],ASC),Planilha1[Vehicle QTY]))