How to concatenate two fields and apply a rating to them

[Anonymous]

I need to concatenate my month field with the year and let them in ascending order, Jan / 2008 fev2008 etc ....

I tried a simple concatenation and then apply the classification but did not work

Here is an example for clarity:

[Greg_Deckler]

I generally create a column like:

= FORMAT([Date],"yyyymm") 

And then use that as my Sort By column for the friendly display name column.

[Anonymous]

@Sean @Greg_Deckler

I forgot to say that the fields are from different tables, the way to do it would be the same?

[Greg_Deckler]

*should* 🙂 You would want to create your new "sort by" column in the same table as your date display field.

[Sean]

@Anonymous You'll have to use the function RELATED(TableName[Column]) for one of them

[Sean]

@Anonymous if you are in Table 1 doing this

 = Table1[Column1]&" - "&RELATED(Table2[Column2])

Let me know if this works.

[Anonymous]

@Sean @Greg_Deckler

the following error is occurring:

"Unable to determine a single value for the 'Month' column in the 'dmegf_mes' table. This can happen when a measure formula refers to a column that contains many values, without specifying an aggregation such as min, max, count or sound for a unique result. "

my expression: = NewColumn dmegf_mes [Month] & "-" & RELATED (dmegf_ano [Year])

[Sean]

@Anonymous Hit Create New COLUMN - NOT Measure!

[Anonymous]

@Sean

that's what I'm doing, I'm going the option to create a new column and not measured

[Sean]

@Anonymous

NewColumn  =  dmegf_mes [Month] & "-" & RELATED (dmegf_ano [Year])

[Anonymous]

@Sean

the same error still occurs,

"Could not determine a single value for the 'month' column in the 'dmegf_mes' table. This can happen when a measurement formula refers to a column that contains many values, without specifying an aggregation such as min, max, count or sound for a unique result. "

[Sean]

@Anonymous show me what's in both columns - select each and show me whats in them (formula bar and data type)

the formula works - look

[Sean]

@Anonymous

Create a New Column= TableName[Month]&" - "&TableName[Year]

this will give you => Month - Year