Forum Discussion
CombineValues() truncates second entry - not sure why?
In a direct query model - I'm trying to created a relationship using CombineValues. The source columns are all type text and appear as follows: Table: Jobs [WO] [SU] [SE]...
Direct query allowed you to create a column ?
Try like = Jobs[WO] & "-" & Jobs[SU]
This query is specifically optimized for creating calculated columns in direct query models.
https://docs.microsoft.com/en-us/dax/combinevalues-function-dax
The order of the syntax is set by the DAX formula, with the delimiter listed first - then the columns.