combined values from 2 column

[Anonymous]

hi all,

Need some help to combine the value from 2 columns.

Fisquarteryr = COMBINEVALUES("Q",mydata[fiscalyrNo],mydata[quarterno])

I got 15Q1, how should i write the dax so that it look like 2015Q1

Thanks so much!

fiscalyrNo	quarterno
15	1
15	2
16	3
17	4

[AlB · Accepted solution]

Hi @Anonymous 

Try

Fisquarteryr = "20" & COMBINEVALUES("Q",mydata[fiscalyrNo],mydata[quarterno])

Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

Cheers  

[Anonymous]

@AlB Thank you so much!