Forum Discussion

Yaniv's avatar
Yaniv
Helper I
9 years ago
Solved

Insert blank value based on another field

Hi,   I have a table named 'service'. I want to create a new calucuated column that says if the field 'done' (date field) is blank do not insert any value but if the 'done' field is not blank inse...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Yaniv,

     

    I changed the data type of Service[Done] from Text to Date/Time, delete and recreate the calculated column Service[DoneDate], everything worked.

     

    I have sent you the modified pbix file through private message.

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Yaniv,

 

I changed the data type of Service[Done] from Text to Date/Time, delete and recreate the calculated column Service[DoneDate], everything worked.

 

I have sent you the modified pbix file through private message.

 

Best regards,
Yuliana Gu

Yaniv's avatar
Yaniv
Helper I
8 years ago

Hi v-yulgu-msft,

 

I also tried to do that but the option of changing to date format was grayed out.

Can you please advise me how did you do that?

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Yaniv,

     

    Was my suggestion helpful to you? If yes, would you please kindly mark the corresponding reply as an answer?

     

    Best regards,
    Yuliana Gu