Forum Discussion
concat month/week
Hello, I am trying to concat the fiscal month of the year + "," + the fiscal week of the year but the below DAX measure is not working. I am trying the replicate the below screenshot that I have ...
https://dax.guide/combinevalues/
or
https://dax.guide/concatenate/
You're creating a calculated column, not a measure. SELECTEDVALUE should not be used in this context.
Also, remember that you can concatenate using the operator: &.
Best
D
or
https://dax.guide/concatenate/
You're creating a calculated column, not a measure. SELECTEDVALUE should not be used in this context.
Also, remember that you can concatenate using the operator: &.
Best
D
Thanks for the reply but the new column button is grayed out. I believe I am unable to create new columns because the data source is pulling from a sales cube. Is there a measure I can use instead of creating new column?
- Probably you can but I know from experience that all measures, members and actually everything you need should be defined in the cube, not outside.
Best
D