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

HI v-yulgu-msft,

 

Yes, there is a mistake in the screenshot. The column source is done and not 'created' but they are same data type (date). I haven't created any relationship for this table.

Appreciate your assistance. 

 

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Yaniv,

 

Could you please share your pbix file?

 

Regards,
Yuliana Gu

  • 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

    v-yulgu-msft,How can I shre it with you? I haven't find an option to attach file to a message here.

    Am I missing something? 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Yaniv,

     

    Can you see this option when posting a reply?

    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,

     

    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