Forum Discussion

BeeleJa's avatar
BeeleJa
Icon for Helper I rankHelper I
5 years ago
Solved

SUMIF to DAX single value to repeat

Hi All,   Can anybody assist with translating this Excel fomula to DAX.   =SUMIFS(S:S;K:K;K108;M:M;"INT_REPAIR";P:P;"Service")   The result I am looking for is a Column where the amount listed ...
Need Help
  • BeeleJa's avatar
    BeeleJa
    5 years ago

    amitchandak - many thanks for the provided solution, it is providing the result I was looking for

    Rgds

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

BeeleJa , create a new column

sumx(filter(Table, [CASEID] =earlier([CASEID]) && [PRODUCTGROUPID] = "Service"),[P_AMOUNT])+0

BeeleJa's avatar
BeeleJa
Icon for Helper I rankHelper I
5 years ago

amitchandak - many thanks for the provided solution, it is providing the result I was looking for

Rgds