Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need Help with DAX

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?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Please share the excel file.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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