lists

2 Topics

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?
Anonymous
3 years ago Place DAX Commands and Tips
484Views
0likes
1Comment
Create list of values in order to parse it into a filter with IN
Hi everyone, I have a table that has the following structure: Letter Letter Group A 1 B 1 C 1 D 2 E 2 F 2 G 3 H 3 I 3 I would like to get a list of letters by chosing a letter group. This list would then be needed in a FILTER segment of a CALCULATE function. An example would be as follows: CALCULATE( sum('Table'[Values]), FILTER( 'Table', 'Table'[Letter] in {listofletters} ) ) where listofletters is a list of all letters from letter group 2 (so D, E, F) As you can see, I am attempting to sum up all values of table 'Table' that are associated with the list of letters from Letter Group 2. My questions are the following: 1) Is my application of the FILTER function correct i.e. is it possible to parse in a list of values in the FILTER function so CALCULATE is only summing up values associated with the list of letters? 2) What is the proper DAX command in order to obtain such a list of letters? Thank you for your help in advance!
Solved
ThomasSan
3 years ago Place DAX Commands and Tips
8.5KViews
0likes
3Comments