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

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.

 

  • 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

  • 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