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.
Seems like this shouldn't be that hard, but I'm struggling. I have two tables
Project Table
Project ID |
0000001 |
0000002 |
ProjectStatus Table
Project ID | Status Date | Team | StatusInd |
0000001 | 12/19/20 | PMO | Red |
0000001 | 12/12/20 | PMO | Green |
There are several reports I would like to show the latest(most recent) statusInd for a Project hardcoded to PMO team. In the example, want to show Project 000001 = Red.
Should this just be a measure or Dax? What would the formulat look like. Been searching, but haven't gotten exactly what I need. TIA.
Solved! Go to Solution.
@dude95
Create a table visual and insert the Project ID from Project Table and create the following measure
Measure =
var _Date =
MAXX(
FILTER(
Proejctstatus,
Proejctstatus[project id] = SELECTEDVALUE(Project Table[Project ID])
),
Proejctstatus[Status Date]
)
var _Status =
MAXX(
FILTER(
Proejctstatus,
Proejctstatus[project id] = SELECTEDVALUE(Project Table[Project ID]) && Proejctstatus[Status Date] = _Date
),
Proejctstatus[StatusInd]
)
return
_Status
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
This was perfect - I just added this to the end so that all projects would still be displayed even if they didn't have a PMO status report submitted yet. Thanks for a great solution!
var _AllStatus =
concatenate(_Status, "")
return
_AllStatus
@dude95
Create a table visual and insert the Project ID from Project Table and create the following measure
Measure =
var _Date =
MAXX(
FILTER(
Proejctstatus,
Proejctstatus[project id] = SELECTEDVALUE(Project Table[Project ID])
),
Proejctstatus[Status Date]
)
var _Status =
MAXX(
FILTER(
Proejctstatus,
Proejctstatus[project id] = SELECTEDVALUE(Project Table[Project ID]) && Proejctstatus[Status Date] = _Date
),
Proejctstatus[StatusInd]
)
return
_Status
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |