Forum Discussion

Iamnvt's avatar
Iamnvt
Icon for Continued Contributor rankContinued Contributor
7 years ago
Solved

Manual Data input for calculated columns

hi,   how can I enter a data manually for a calculated column in DAX? I know we can do that easily with Enter Data table in Power Query; however, I am wondering if we have an DAX function that let ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Iamnvt 

    Open Edit queries, create an index column (from 1) for the exsiting table

    Then close&&apply,

    in the data model,

    Create a column

    Column = SWITCH([Index],1,"a",2,"b",3,"c",4,"d")

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Iamnvt 

Open Edit queries, create an index column (from 1) for the exsiting table

Then close&&apply,

in the data model,

Create a column

Column = SWITCH([Index],1,"a",2,"b",3,"c",4,"d")

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.