DAX Expression to extract value from one column based on a different column.
I have one table called "Task" - the task table contains multiple projects. The data source is combined to include multiple projects. Each Project has task outline numbers, Parent task name and outline levels (not sure that this is relevant).
Question. How do I extract the outline number for each of the parent Task. Because there are several different projects in the source data I will have multiple instances of the same outline number and this keeps causing an error in my extraction.
I have posted the challenge to Power BI forum. Here is the link:
[login to view URL]
16 freelancers are bidding on average $26 for this job
Hello. I am from Malaysia. I had a quite professional skills in excel and Spreadsheet. I've done few task regarding data entry before. Glad if you contact me for this project.