Urgent Help --- Displaying month names as a column header in table not in a matrix

[Anonymous]

Hi everyone,

   I want to show the multiple columns along with measures also shown in a table format.
I have a issue in one of the measure in that measure I am displaying month wise calculations in charts its showing correct but in table
I dont know how to give the measure of the month names in column header..

The measure is 
Forecast Amount =
VAR tmpCalendar = ADDCOLUMNS('Calendar date',"Month",MONTH('Calendar date'[Date]),"Year",YEAR('Calendar date'[Date]),"MonthYear",VALUE(YEAR('Calendar date'[Date]) & FORMAT(MONTH('Calendar date'[Date]),"0#")))
VAR tmpBilling = ADDCOLUMNS(Test,"MonthYearBegin",VALUE(YEAR(Test[hclmma_startdate]) & FORMAT(MONTH(Test[hclmma_startdate]),"0#")),
"MonthYearEnd",VALUE(YEAR(Test[hclmma_enddate]) & FORMAT(MONTH(Test[hclmma_enddate]),"0#")))
VAR tmpTable =
SELECTCOLUMNS(
FILTER(
GENERATE(
tmpBilling,
SUMMARIZE(tmpCalendar,[Year],[Month],[MonthYear])
),
[MonthYear] >= [MonthYearBegin] &&
[MonthYear] <= [MonthYearEnd]
),
"Total",Test[Net CIM],
"Count of Days",Test[Days in Month],
"Remaining Days",Test[Dayys]
)
RETURN SUMX(tmpTable,([Total]/[Count of Days])*[Remaining Days])

I dont know how to display the measure into month of column header in table other measures and other columns are added into table is working but the month wise is not working I dont want to show in matrix chart also. I need your help. kindly help me as soon as possible.  My output like like this

Advance thanks to all,

[MFelix]

Hi @Anonymous ,

The use of measures in table gives you a single column value so you will not be abble to show this values in another format if you don't add another column that gives you that context.

When you refer that this is giving the correct value on a chart I assume you are using a month column on the X-axis correct?

If this is the case the Month column is what is giving you the context for the calculation to be made month byt month otherwise everything will appear as one value.

Only option is to use the matrix as you refer or to create a measure for every month since the table visualization does not allow you to split the a single measure in months by column only by row.

[Anonymous]

@MFelix 

  Thanks for your reply. First I tried matrix chart only It splits month wise correctly but I have four measures and four columns to sum in the values it also splits upon month wise. I dont want to split upon month wise  that's y I am using table chart. In matrix chart multiple columns added in the rows it goes for drill down also it doesnt show in a row of headers...Is it possibe to do all in matrix?