Phoenix - Your AI AssistantPOWER BI DAX Formula to Replicate Excel Model
- Posted:
- Proposals: 9
- Remote
- #2612432
- Awarded
Karachi 
Description
Experience Level: Entry
Hi,
No time wasters here, I need the solution to my problem in order for you to qualify for an interview.
Potential of future work on successful completion of the task.
I have an excel model that is working perfectly, however, I need to replicate that in Power BI using DAX, but I cannot solve the last step of the model due to a circular dependency. In the excel file you will see that column C is based on column E. Column D is based on column C and column E is based on column D as well, you will understand when you look at the Excel file.
This is where I get stuck in Power BI, to replicate column C, D and E exactly as displayed in Excel.
Please see the attached Excel and Power BI files. Also in your response to present the solution please start the post with "Power BI Solution"
Thanks in advance for your time.
No time wasters here, I need the solution to my problem in order for you to qualify for an interview.
Potential of future work on successful completion of the task.
I have an excel model that is working perfectly, however, I need to replicate that in Power BI using DAX, but I cannot solve the last step of the model due to a circular dependency. In the excel file you will see that column C is based on column E. Column D is based on column C and column E is based on column D as well, you will understand when you look at the Excel file.
This is where I get stuck in Power BI, to replicate column C, D and E exactly as displayed in Excel.
Please see the attached Excel and Power BI files. Also in your response to present the solution please start the post with "Power BI Solution"
Thanks in advance for your time.
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
hello, can you attach the excel file so we can better understand the problem? (you can only use a few rows if it better suits you). If there is circular dependency, why is it not a problem in Excel and only PBI? Thanks.