Need Help with DAX

[Anonymous]

Hi All. I have been given an excel file for refrerrence from which, looking at the formulas used in the excel, I need to create the same in power bi calculated column. Below I am attaching the excel formula for your referrence. Any help would be much appreciated. Thanks in Advance!

=IF(A7="","",
IF(SUMPRODUCT(--ISNUMBER(SEARCH({"ITW"},L7)))>0,"inbound",
IF(SUMPRODUCT(--ISNUMBER(SEARCH({"DTW"},L7)))>0,"delivered to WH",
IF(N7="(blank)","not confirmed",
IF(OR(T7=1,T7=2),
IF(SUMPRODUCT(--ISNUMBER(SEARCH({"zones"},K7)))>0,"Zones Service",
IF(N7>TODAY()-3,"new PO",
IF(N7<TODAY()-30,"30+days open","inbound"))),
"inbound")))))

This is the formula which is being used in the excel, below i am sharing the exact columns name of what excel cell refers:

A7 = itemid
l7 = ets mgmt follup cmnts
N7 = po conf date
T7 = est trans time
k7 = manufacturer name

How can we achieve this in power bi calculated column using DAX? Also, The table name in power bi would be "test". 

Can we also achieve this using M Query?

[Anonymous]

Please share the excel file.

[Anonymous]

hi @Anonymous I can share a screenshot of the excel file. Please refer the below picture, so the column we need to create in power bi is referred as "PO aging" in the excel below and that "PO aging" has the above formula which i have posted earlier.

"PO aging" column is present in the 2nd screenshot