Forum Discussion

kunal_mehta1's avatar
kunal_mehta1
Icon for Helper I rankHelper I
3 years ago
Solved

Dax Query or a different solution

Hi Team, I have this sample data where i have C Project and O project codes. The C and O Projects have dollar values like forecast, approval, spent, etc. Few C Projects have O Projects with the same ...
"Need Help"
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    DAX Calculated Column=IF(LEFT(Table[Project Code],1)="C",Table[ABC]+SUMX(FILTER(Table,Table[Project Code]="O"&MID(EARLIER(Table[Project Code]),2,4)),Table[ABC]))

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

DAX Calculated Column=IF(LEFT(Table[Project Code],1)="C",Table[ABC]+SUMX(FILTER(Table,Table[Project Code]="O"&MID(EARLIER(Table[Project Code]),2,4)),Table[ABC]))