Excel formula to Dax Calculated column

[Anonymous]

Hi, 

The below is the Excel Formula Now I want to  convert into DAX Calculated column. Please Suggest on this one

1. =+SUMIFS(N(Column):N(Column),$J(Column):$J(Column),"Table (NS) [P_C]",$A(Column):$A(Column),$A24(Value))/XLOOKUP($L24(Value),'FX BDG 2022'!$A(Column):$A(Column),'FX BDG 2022'!$B(Column):$B(Column),"error",0)

2. =+IF($Q24(Value)="9L Cases",R24(Value)*9,R24(Value))

Thanks

[Anonymous]

Can anyone suggest to me

[amitchandak]

@Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.