Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Add the same date to many rows

Hi, In this table I want to add the reel starting date for all row with the same description:   Like this: For all rows with F26 in description: 2018-06-06 11:58:43 for Reel_Start_Date For a...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi FRG,

     

    When a new row has been added, the calculate column can also work. Do you mean the new row be added is not in your three conditions? If you are, you can add another condition in the switch block.

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi FRG,

 

Create a calculate column [Reel_Start_Date] using DAX formula as below and check if it works well.

 

Reel_Start_Date =
SWITCH (
    table[description],
    "F26", "2018-06-06 11:58:43",
    "C31", "2018-06-06 11:58:43",
    "E76", "2018-05-22 22:09:39"
)

You can click Reel_Start_Date column and change type from text to datetime through clicking Modeling->Format.

 

Hope it's helpful to you.

 

Jimmy Tao