Excel formula in power bi dax

[Anonymous]

Hi All,

How to approch this kind of problem. 

Not able to implement   

Stock=IF(SUMIF(Data!J:J,REPORT!$A6&"NEWBHW",Data!D:D)=0,
SUMIF(Data!J:J,REPORT!$A6&"NEXBHW",Data!D:D),SUMIF(Data!J:$J,REPORT!$A6&"NEWBHW",Data!D:D))

Thanks

[v-frfei-msft]

Hi @Anonymous ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.