Hard Code Values into a Matrox Table

[Anonymous]

Hi Experts

I want to add a dax measure and or a calculated column to Hard code values into a matric table based on Period (months)

End result show be

The main FACT Table is Input and column with M values are in M Column

M0	M1	M2	M3	M4	M5	M6	M7	M8	M9	M10	M11	M12	M13	M14	M15	M16	M17	M18	M19	M20	M21	M22	M23	M24	M25	M26	M27	M28	M29	M30	M31	M32	M33	M34	M35
0	0	0	0	0	0	0	0	0	0	2	1	1	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

[amitchandak]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

Hi Amit - I would like to added the following Values to my FACT Table (Input) as a calculated column for the following month....Hard coded values...

[amitchandak]

@Anonymous ,  Try a new column like

Date(2012, 1+ right([M column], len([M column])-1),1)

[Anonymous]

Hi Amit - this give dates not the values in the value column

[amitchandak]

@Anonymous , Try like

Switch(true(),
[M column] in {"M10"} , 2,
[M column] in {"M11","M12","M13","M14","M15","M16","M17"} , 2,
0
)

[Anonymous]

Hi Amit - Agree but it has to be for those date also....