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