Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

combined values from 2 column

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!

 

fiscalyrNoquarterno
151
152
163
174
Need Help
  • AlB's avatar
    AlB
    6 years ago

    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  Datanaut

     

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    6 years ago

    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  Datanaut

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      AlB Thank you so much!