Forum Discussion

Helper II

1 year ago

Excel to Powerbi conversion formula help

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,AX...

Helper II

1 year ago

lakewood production report.pbix

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

Community Support

1 year ago

Hi ahmer_malick ,

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

Best Regards,

Lakshmi

v-lgarikapat
Community Support
1 year ago
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:

A mapping of column names from the Excel file to the sample dataset.

Clarification on which columns are derived vs. existing.

An overview of the four tables included in the sample dataset:

Which tables are dimension tables?

Which table is the fact table?

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
  Helper II
  1 year ago
  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
    Community Support
    1 year ago
    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