I don not understand the reason needed for adding a new .xer path at the end. You transform data (edit Parameters) @ 12:45 in the video and it updates the count of task from 47 to 2449. Why do you need to do this if your reading the latest .xer file? I would always want it to read the latest .xer file in a folder and not an old file. However, mine is also giving me a count that is much less than my actual .xer has in it. Is there a way to make this accurate using the latest .xer?
I'm adding new xer to make it clear that you can use any xer in this report, not the same project only. To read the latest xer in folder. In power query, before read the xer read the folder and sort by file date desc then select the first record, then read the xer. For giving you less count, it should give you accurate count. I cannot predict what's wrong.🌹🌹🌹
In the next vidoes we'll discuss manythings. Anyway, upload the two XERs in the same way. Then create to task table. You can compare these tables by task_code field in power query, excel or power bi.🌹
Dear sir, In blank query and file content reading I am getting error message as below. Dataaformat.Error:The supplied file path must be a valid absolute path. What would be solution for this? Kindly help
Your content is really really useful. Totally can relate with real Project scenario. Keep up the good work.
Very useful. Waiting for the next video
Thank you so much Eng. Osama, I was looking for it for a long time!
That'a only the begining. Enjoy🌹
Very informative coaching. Many thanks my dear brother
واحشني أوي يا إيهاب 🌹🌹🌹🌹🌹🌹🌹🌹🌹
Expecting the tutorials regularly
Thank you very much, I waiting the next topics
Thank you very much sir. It is very informative.
Many thanks for the video, great tutorial!
إن شاء الله يكون في ميزان حسناتك . كل الإحترام والتقدير . مبدع.. سؤال : لا أستطيع إيجاد TASKFIN - (Activity Past Period Actuals) من قائمة الأعمدة
Thanks.very much
I don not understand the reason needed for adding a new .xer path at the end. You transform data (edit Parameters) @ 12:45 in the video and it updates the count of task from 47 to 2449. Why do you need to do this if your reading the latest .xer file? I would always want it to read the latest .xer file in a folder and not an old file. However, mine is also giving me a count that is much less than my actual .xer has in it. Is there a way to make this accurate using the latest .xer?
I'm adding new xer to make it clear that you can use any xer in this report, not the same project only.
To read the latest xer in folder. In power query, before read the xer read the folder and sort by file date desc then select the first record, then read the xer.
For giving you less count, it should give you accurate count. I cannot predict what's wrong.🌹🌹🌹
I did the step .but i can not see the xer fie.
Is it required step before this step
Which step are you talking about?🌹🌹🌹
Hi Mr Osama thank you for sharing, i have a question if i want to compare between BL & up how can i do?
In the next vidoes we'll discuss manythings.
Anyway, upload the two XERs in the same way. Then create to task table.
You can compare these tables by task_code field in power query, excel or power bi.🌹
@@osama.hassanin I greatly appreciate your effort to share knowledge.
Dear sir,
In blank query and file content reading I am getting error message as below.
Dataaformat.Error:The supplied file path must be a valid absolute path.
What would be solution for this?
Kindly help
Check if the path in the parameter query contains high quotations in the begin and end, remove them
It's resolved thanks a lot for your guidance.
You have the deepest knowledge of excel power bi and Primavera p6
@@mohammedabdulmoiz5024 old man experience 😃🌹
@@osama.hassanin
Many of us can be benefited from your experience. Kindly keep posting as per your convenience.
Thank You So Much Sir.How i can contact your for P6 BI Training
Sorry, I've no time for providing training🌹
@@osama.hassanin can you suggest Valuable course from others ?
Hi Osama , Wen next Video in this series