Help on transferring a table from Excel to Power BI

[TANA]

Hi,

I am working on projects. And we have progress reports every month. The format of progress report in excel is like attached. The target we would like to achieve is to have them shown dynamically in Power BI with filters. When you select different projects in the filter then, the table will automatically be updated with different cost and comment information. By the way, the comment is also retrieved from excel, which can be long text. Can you give me directions on this? Thanks, appreciated!

[Nathaniel_C]

Hi @TANA ,

@KenPuls  has written a great book, M is for (Data) Monkey, gives you lots of tips, tricks and patterns.
@MattAllington   who wrote Supercharge Power BI is really good with these type of inquiries!

Both these books are around $30 US on Amazon or check out their website for training. https://skillwave.training/about-us/
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[TANA]

Nathaniel:

Thanks for your reply. However, this is not what I was looking for. 

[Nathaniel_C]

Hi Tana,

Ok, I understand...however your request is so general and the amount of knowledge that it would take all day to write this up.  Maybe I do not understand your request.  You may want to read the link below and repost your question.


https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Nathaniel