Hard Code Values into a Matrox Table

Question

Hi Experts&nbsp;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 beThe main FACT Table is Input and column with M values are in M ColumnM0M1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16M17M18M19M20M21M22M23M24M25M26M27M28M29M30M31M32M33M34M35000000000021111111000000000000000000

amitchandak · Answer

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 · Answer

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...&nbsp;

amitchandak · Answer

Anonymous ,&nbsp; Try a new column like 
Date(2012, 1+ right([M column], len([M column])-1),1)

anonymous · Answer

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

amitchandak · Answer

Anonymous , Try like
&nbsp;
Switch(true(),[M column] in {"M10"} , 2,[M column] in {"M11","M12","M13","M14","M15","M16","M17"} , 2,0)

Forum Discussion

Hard Code Values into a Matrox Table

6 Replies

Related content

Formatting Value of Table

PowerBI - Matrix table, hide values used only for a visual calculation

Table Call Value Formatting Options

Return "Specific value" from table 1, if not found, return value from table 2

Parsing list values in a nested table

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

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

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