Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Team,
I have two SharePoint lists. One is with Project details and another with weekly progress for each project. The Project table has Project name and Benefits. The Progress table has Project(Lookup from column from Projects table), Date, and Weekly Progress. In Progress Table, there are multiple rows for weekly progress for each project with the date.
I would like to merge the tables and show the fields below in a table visual in PowerBI.
Please help me to achieve the result in PowerBI
Regards,
Alwin
Solved! Go to Solution.
Hi @allwynbazil
If both tables have Project column, you can build a relationship between them on Project column, then bring columns from corresponding tables into the table visual.
For the weekly progress, you can create the following measure
Latest Progress =
VAR _lastDate = MAX ( 'ProgressTable'[Date] )
RETURN
CALCULATE (
MAX ( 'ProgressTable'[Progress] ),
'ProgressTable'[Date] = _lastDate
)
Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @allwynbazil
If both tables have Project column, you can build a relationship between them on Project column, then bring columns from corresponding tables into the table visual.
For the weekly progress, you can create the following measure
Latest Progress =
VAR _lastDate = MAX ( 'ProgressTable'[Date] )
RETURN
CALCULATE (
MAX ( 'ProgressTable'[Progress] ),
'ProgressTable'[Date] = _lastDate
)
Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thanks for looking into the issue @v-jingzhang. I fixed this issue using Bookmarks and Selection Options.
And I used the measure as you suggested to display the latest progress.
@allwynbazil , Have you tried Merge in Power Query
Merge: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |