Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have 3 tables, [resource] -> [timesheet] -> [project]
Resource table:
ID | Resource |
1 | Paul |
2 | Frank |
Timesheet table:
ResourceID | ProjectID | Date |
1 | 6 | 27.11.2023 |
2 | 7 | 27.11.2023 |
1 | 8 | 28.11.2023 |
2 | 9 | 28.11.2023 |
Project table:
ID | ProjectName |
6 | SE blablabla |
7 | TE blablabla |
8 | UE blablabla |
9 | VE blablabla |
Now I'd like to add a column to the reource table with the left 2 characters of the latest ProjectName they've worked on. So in case of Paul, it would result in "UE" and in case of Frank it would result in "VE"
Can anyone help me with the column DAX formula?
Solved! Go to Solution.
It's not working as it is not the MAX[projectname]. It should be the projectname where they worked on the latest.
Anyone?
which is not what was asked, I did it.
if you need the full name of the project, just write it like this
User | Count |
---|---|
88 | |
88 | |
74 | |
69 | |
57 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |