cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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

 

 

5 REPLIES 5
Super User I
Super User I

R or Power BI?

 

i suggest going through the guided learning videos 

 

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

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

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

Anonymous
Not applicable

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

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

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?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors