Forum Discussion
Transform data from a table with subtasks to a new task table
Community ChampionR or Power BI?
i suggest going through the guided learning videos
https://powerbi.microsoft.com/en-us/guided-learning/
vanessafvgThanks for the info.
The problem in my case is the data model which I can not change. So I need to change it when importing the tables. I was assuming that when I do an Advance Query the language is R. Is this incorrect?
I mixed the letter.. M Language, not R.
- vanessafvg
After you have imported the tables you can change it the way you like, m is the language yes but for the most part you should be able to use the gui to get done what you need.
You will probably get more responses if you try doing it and come up with specific issues, so my suggestion is to start importing and watch the videos and when you hit issues post them here.
Thanks vanessafvg
I already did the import and it works correctly for the native projects, the problem is that for two projects I need that breakdown an I was not able to do it.
What I was thinking was to make some type of if statement in the import so that a task with proj ID=1 would in fact point to Proj ID = 10 so that way I could link to a created table with the new projects and not use the original ones.
This was the visuals I buit previously would work exactly the same but poiting to the new inserted table.
Is this possible?