Transform data from a table with subtasks to a new task table

[Anonymous]

I have the following data structure:

Id  ProjName

1   Proj1

2   Proj2

3   Proj3

And subtask info:

id ProjId TaskName

1 1          Task1

2 1          Task2

3 2          Task3

4 3          Task4

5 3          Task5

6 3          Task6

7 2          Task7

But I need to breakdown the Projects Table into something like:

Id  ProjName

1   Proj1

2   Proj2

3   Proj3

4   Proj4

5   Proj5

And to point Task5 to Proj4 and Task6 to Proj5 maintaining the rest without changes. What type of Query Can I make? I'm completly newbie at R.

Thanks

[vanessafvg]

R or Power BI?

i suggest going through the guided learning videos 

https://powerbi.microsoft.com/en-us/guided-learning/

[Anonymous]

@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?

[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.

[Anonymous]

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?

[Anonymous]

I mixed the letter.. M Language, not R.