Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have this datasource:
key | Item Number | Project ID | Project Due Date |
0 | 948 | RCN-026 | 202352 |
1 | 937 | RCN-026 | 202352 |
2 | 801 | RCN-026 | 202352 |
3 | 302 | BJS-682 | 202238 |
4 | 143 | BJS-682 | 202238 |
5 | 989 | BJS-682 | 202238 |
6 | 791 | PPT-112 | 202352 |
7 | 702 | PPT-112 | 202352 |
8 | 476 | PPT-112 | 202352 |
9 | 446 | PPT-112 | 202352 |
I have a slicer to select some project IDs
I want to have two text boxes: one to display all the project IDs selected, one to dislpay the related due date FOR EACH project.
I use this formula to display the projects:
selectedProjects = CONCATENATEX(VALUES(Table[Project ID]), [Project ID], UNICHAR(10))
And this one to display the due dates:
dueDate = CONCATENATEX(VALUES(Table[Project Due Date]), [Project Due Date], UNICHAR(10))
I obtain this:
But expected result is this:
It has to be dynamic when I select other projects...
Anyone can help me on this?
Thanks a lot
arthurld
Solved! Go to Solution.
Hi, @Anonymous,
the reason you only get two dates with your current measure is because VALUES returns the distinct values of the argument.
Could you try to write your measure like this instead:
dueDate =
CONCATENATEX (
ADDCOLUMNS (
VALUES ( 'Table'[Project ID] ),
"tmp", CALCULATE ( MIN ( 'Table'[project due date] ) )
),
[tmp],
UNICHAR ( 10 )
)
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Hi, @Anonymous,
the reason you only get two dates with your current measure is because VALUES returns the distinct values of the argument.
Could you try to write your measure like this instead:
dueDate =
CONCATENATEX (
ADDCOLUMNS (
VALUES ( 'Table'[Project ID] ),
"tmp", CALCULATE ( MIN ( 'Table'[project due date] ) )
),
[tmp],
UNICHAR ( 10 )
)
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.