lists

3 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
481Views
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
Problems pulling SharePoint data with Persona or Choice data type to Power BI
Hi everyone, I'm using a SharePoint list to track work items. For consisntency I use the Person or group data type for "Requestor" and "Assigned To" and Choice data type for "Output type". I would like to build a PM dashboard with this data but when I connect to Power BI using Online Services, "Sharepoint list" i get a generic [Table] or [List] for anything that's not in a text of number data type. If I go ahead an visualise the values are not shown , I only see a "list" item in any X axis i make. Does anyone know how I can pull the actual values or the tables that have those values so I can build a model? Thank you in advance.
Solved
Robot33
4 years ago Place Desktop
946Views
0likes
2Comments