Forum Discussion

Yaniv's avatar
Yaniv
Icon for Helper I rankHelper 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
    9 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
Icon for Helper I rankHelper I
9 years ago

v-yulgu-msft - Unfortunately, I can't. I just have the option ot attach an image file. 

Please see the screenshot below.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 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
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Yaniv,

     

    As suggested in above link, could you please upload and share the sample files on OneDrive, Dropbox etc?

     

    Regards,
    Yuliana Gu

  • Yaniv's avatar
    Yaniv
    Icon for Helper I rankHelper I
    9 years ago

     

    Hi v-yulgu-msft,

     

    I sent you a private message.

     

  • Yaniv's avatar
    Yaniv
    Icon for Helper I rankHelper I
    9 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
    Icon for Microsoft Employee rankMicrosoft Employee
    9 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