ADDCOLUMNS using an existing measure

[Stanzarectah]

Hi,

I have an existing table that has a measure called 'Metrics'

I want to add a few more columns using the ADDCOLUMNS function to add a 12 months (one month per column)  right after the metrics value column

I am able to create one measure say, 'July' and add it to the table 

July = CALCULATE(MeasureTable_Metrics[Metrics], DateTable[Fiscal Month] = 1)

Obviously I do not want to create a measure for each month so I want to use ADDCOLUMS :

AddColumns = ADDCOLUMNS(MeasureTable_Metrics, "July", CALCULATE(MeasureTable_Metrics[Metrics], DateTable[Fiscal Month] = 1))

However I get the following: 

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

Does anyone know why ?

[tamerj1]

Hi @Stanzarectah 

easiest to use a matrix visual. Place the fiscal month on columns then the measure will be sliced automatically. The column total will show your current metrics values. 

[Stanzarectah]

Hi @tamerj1 , sorry I have already tried using matrix but because the metrics column relies on the Name column this can not easily be done.

I have tried the formula ADDCOLUMNS but it never seems to work as I keep gettign the error:

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

[tamerj1]

@Stanzarectah 

Please clarify further