cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Return values related to selected ones

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

1 ACCEPTED SOLUTION
Resident Rockstar

Hi, @Anonymous,

the reason you only get two dates with your current measure is because VALUES returns the distinct values of the argument.

``````dueDate =
CONCATENATEX (
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.

Resident Rockstar

Hi, @Anonymous,

the reason you only get two dates with your current measure is because VALUES returns the distinct values of the argument.

``````dueDate =
CONCATENATEX (
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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.