Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Select values from two tables and paste them into new table

So i want to create a new measure called Person Absence Date that would return absence dates for a person from two tables (

'GAM Absence' and 'GAM AbsenceRequest'. 
 
I wanted to do something like this: 
Person Absence Dates =
VAR selectedName = MAX('Issues'[Assignee])
VAR selectedUID = MAXX(FILTER('GAM Users', 'GAM Users'[name] = selectedName), 'GAM Users'[PersonID])
RETURN CONCATENATEX(
     FILTER('GAM Absence',
            'GAM Absence'[UID] = selectedUID ) ,
     'GAM Absence'[Date] & ", ", ,
     'GAM Absence'[Date],
     ASC )
& CONCATENATEX(
     FILTER('GAM AbsenceRequest',
          'GAM AbsenceRequest'[UID] = selectedUID ) ,
     'GAM AbsenceRequest'[Date] & ", ", ,
     'GAM AbsenceRequest'[Date],
     ASC
)
 
This however returns a list of the dates (one row, dates seperated by commas), not dates in rows. How would i do that?
 
 
1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , Based on what I got Try like

 

Person Absence Dates =
VAR selectedName = MAX('Issues'[Assignee])
VAR selectedUID = MAXX(FILTER('GAM Users', 'GAM Users'[name] = selectedName), 'GAM Users'[PersonID])
RETURN CONCATENATEX(
Distinct( Union( Summarize(FILTER('GAM Absence',
'GAM Absence'[UID] = selectedUID ) ,'GAM Absence'[Date])
, Summarize(FILTER('GAM AbsenceRequest',
'GAM AbsenceRequest'[UID] = selectedUID ) ,'GAM AbsenceRequest'[Date])))
'GAM Absence'[Date], " , "
ASC )

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.