Forum Discussion
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 ...
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]))
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]))