Excel to Powerbi conversion formula help

[ahmer_malick]

Need Help with 2 formula . I have a report in Excel , I would be move it in PWBI as its taking alot

Formula one in excel :-

=IF(Z3="Y","N",IF(H3=1,"n",IF(AND(AN2="Y",F2=441277),"Y",IF(AND(J3>=H3,AX3="not@pack"),"N", IF(Q3>0,"Y",(IF(OR(AM3="Y",AC3="Y",AI3="Y",AE3="Y",(AND(W3="Y",Z3="N",X3="N"))),"Y","N")))))))

Formula 2 

=IF(C2="","N",IF(AL2="Y","N",IF(AND(AN5="Y",C2=C5),"N",IF(AND(D2=525,J2>0,AX2="NOT@PACK"),"N",IF(AND(AN4="Y",C2=C4),"N",IF(AND(AN2="Y",C2<>C3,J2<H2),"Y",(IF(H2=1,"N",(IF(AND(AN2="Y",AN3="N"),"Y","N"))))))))))

[v-lgarikapat]

Hi @ahmer_malick ,

Thanks for reaching out to the Microsoft fabric community forum.

@FBergamaschi 

Thanks for your prompt response

@ahmer_malick 

Thanks for sharing the Power BI (.pbix) file earlier. I tried accessing it via the OneDrive link, but I’m getting an error saying the item might have been deleted, expired, or I don’t have permission to view it (screenshot attached).

Could you please re-share the file with the correct permissions? 

Thanks in advance!

Best regards,
Lakshmi Narayana

[ahmer_malick]

lakewood production report.pbix

could you check now and let me know if its opening or not 

[v-lgarikapat]

Hi @ahmer_malick ,

Thanks for sharing. I'm now able to download it.

Best Regards,

Lakshmi 

[v-lgarikapat]

Hi @ahmer_malick 

Apologies for the follow-up, but I would appreciate a bit more clarity regarding the dataset requirements. Could you please help with the following:

1. A mapping of column names from the Excel file to the sample dataset.
2. Clarification on which columns are derived vs. existing.
3. An overview of the four tables included in the sample dataset:
• Which tables are dimension tables?
• Which table is the fact table?
4. Currently, there don't appear to be any relationships defined  is that intentional?

Your input will help ensure I understand the structure correctly and proceed accordingly.

Thanks in advance!
Best regards,
Lakshmi

[ahmer_malick]

1- 

The original file is here 

FCWIWV_B.xls

2-The dimension and fact tables are built after the fcwiwv report which i get from the system. Anything after PO received or Quantity Received is derived

3- There are no relationships except vendors details from another table and all other have been left intentionally blank.

[v-lgarikapat]

Hi @ahmer_malick ,

Thank you for your prompt responses. I’m currently unable to access the original file could you please reshare it with the correct access permissions? It seems similar to the PBIX file you had shared earlier.

Appreciate your support!

Best regards,
Lakshmi

[v-lgarikapat]

 Hi @ahmer_malick ,

I'm following up to see if you're still experiencing the issue you previously raised. If so, we’d be happy to assist you further. To better understand the problem and provide an accurate solution, please share a sample dataset in a structured text format (rather than an image). Kindly ensure that the data is relevant, free of any sensitive information, and clearly represents the issue.

Additionally, if possible, please include the expected outcome based on the sample data you provide. This will help us guide you more effectively.

Please don’t hesitate to reach out with any further questions or clarifications we’re here to help.

Looking forward to your response.

Best regards,
LakshmiNarayana

[v-lgarikapat]

Hi @ahmer_malick ,

I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.

Thank you for being an active part of the community. Looking forward to hearing from you!

Best regards,
Lakshmi

[v-lgarikapat]

Hi @ahmer_malick ,

I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.

Thank you for being an active part of the community. Looking forward to hearing from you!

Best regards,
Lakshmi

[FBergamaschi]

You need to use the IF DAX function and use colum names instead of cell references

Anyway I see you reference in one row cells of toher rows, this is complex in DAX

But is this you need to build a column or a measure?

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[ahmer_malick]

I need to built a calculated column . We don't post qty as 2 operations occur simultaneously so checking other operation no if anything is posted afterwards in the SHOP order

[FBergamaschi]

This is a complex thing to implement, I believe a visual calculation might be a better solution but without your entire pbix file I cannot help you

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[ahmer_malick]

https://1drv.ms/u/c/2b099a8a26629d49/EcAEcV0Z1qFJmkbHjBWvFEwBdGq3BW073cBJL_QxFzUSyw?e=FeD0Uw 

Please find the attach PBIX file link.