Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hard Code Values into a Matrox Table

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 wit...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous ,  Try a new column like

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

        Anonymous , Try like

         


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