Need Help with DAX

Anonymous — Mon, 05 Dec 2022 06:25:31 GMT

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?

Re: Need Help with DAX

Anonymous — Mon, 05 Dec 2022 05:41:48 GMT

Please share the excel file.

Re: Need Help with DAX

Anonymous — Mon, 05 Dec 2022 05:53:40 GMT

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

topic Re: Need Help with DAX in DAX Commands and Tips

Need Help with DAX

Re: Need Help with DAX

Re: Need Help with DAX