Forum Discussion

ahmer_malick's avatar
ahmer_malick
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...
Need Help
v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi ahmer_malick ,

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

 

Best Regards,

Lakshmi 

v-lgarikapat's avatar
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:

  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's avatar
    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's avatar
      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

      • v-lgarikapat's avatar
        v-lgarikapat
        Community Support
        1 year ago

         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