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 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

 

  • 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.