Forum Discussion
Unable to convert the Excel Formula into Power BI
Dear all Power BI Experts,
Since Last10 days still I am trying to apply the excel formula into Power BI.
But Unable to done it.
Kindly help me to get this Done.
Sample File is attached here (only 2 Project details, in original file lot of project details will be there).
| Input Table | ||||||
| Associate Name | Project/Part Number | Duration/Lead Time | Milestone | Target Date | ||
| Dinesh | 0437S000CG | 7 | Technical documents | 11/30/2022 | ||
| 7 | Order tooling and sampling (C-Samples) | 12/7/2022 | ||||
| 126 | Availability of parts in plant (C-Samples) | 4/12/2023 | ||||
| 7 | C- Sample Evaluation | 4/19/2023 | ||||
| 7 | Order Samples (D-Samples, Initial samples) | 4/26/2023 | ||||
| 14 | PPAP release | 5/10/2023 | ||||
| Dinesh | 0437S000CJ | 7 | Kick Off | 3/29/2023 | ||
| 14 | Risk Classification on part level | 4/5/2023 | ||||
| 7 | RFQ Process | 4/19/2023 | ||||
| 7 | Pre-Sourcing Discussion | 4/26/2023 | ||||
| 14 | PPAP release | 5/10/2023 | ||||
| Suganya | 0437S000SD | 18 | Sourcing Nomination Proposal | 3/15/2023 | ||
| 14 | Sourcing Decision | 4/2/2023 | ||||
| 10 | Order tooling and sampling (C-Samples) | 4/16/2023 | ||||
| 7 | Availability of parts in plant (C-Samples) | 4/26/2023 | ||||
| 14 | PPAP release | 5/10/2023 | ||||
| Out Put Table ( want to automate this Process in Power BI) | ||||||
| Column Name For ref Purpose' | A | B | C | D | E | F |
| Associate Name | Project/Part Number | Duration/Lead Time | Milestone | Target Date | Result | |
| Dinesh | 0437S000CG | 7 | Technical documents | 3/2/2023 | C3 - F3 | |
| Dinesh | 0437S000CG | 7 | Order tooling and sampling (C-Samples) | 3/9/2023 | C4 - F4 | |
| Dinesh | 0437S000CG | 126 | Availability of parts in plant (C-Samples) | 7/13/2023 | C5 - F5 | |
| Dinesh | 0437S000CG | 7 | C- Sample Evaluation | 7/20/2023 | C6 - F6 | |
| Dinesh | 0437S000CG | 7 | Order Samples (D-Samples, Initial samples) | 7/27/2023 | C7 - E7 | |
| Dinesh | 0437S000CG | 14 | PPAP release | 8/10/2023 | 8/10/2023 | |
| Dinesh | 0437S000CJ | 7 | Kick Off | 3/29/2023 | C9 - F9 | |
| Dinesh | 0437S000CJ | 14 | Risk Classification on part level | 4/5/2023 | C10 - F10 | |
| Dinesh | 0437S000CJ | 7 | RFQ Process | 4/19/2023 | C11 - F11 | |
| Dinesh | 0437S000CJ | 7 | Pre-Sourcing Discussion | 4/26/2023 | C12 - E12 | |
| Dinesh | 0437S000CJ | 14 | PPAP release | 5/10/2023 | 5/10/2023 | |
| Suganya | 0437S000SD | 18 | Sourcing Nomination Proposal | 3/15/2023 | ||
| Suganya | 0437S000SD | 14 | Sourcing Decision | 4/2/2023 | ||
| Suganya | 0437S000SD | 10 | Order tooling and sampling (C-Samples) | 4/16/2023 | ||
| Suganya | 0437S000SD | 7 | Availability of parts in plant (C-Samples) | 4/26/2023 | ||
| Suganya | 0437S000SD | 14 | PPAP release | 5/10/2023 |
5 Replies
If Old file is Confused Pls Refer this file
Pls Open Excel and Pls See Every Cells Formula I am sure then only we can align in same line
Hi,
it's not clear what is your desired result
What does it mean C3 - F3?
It is Column Name Sir,
If you open my excel sheet, then I hope it will be understandable.
Hi,
this is the preview (i don't open files if not needed)
but unfortunatly i can't undestand what you need?!?
