Forum Discussion
Yaniv
Helper I
Helper IInsert 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...
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
YanivHelper I
Helper IHi 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
Microsoft Employee
Microsoft EmployeeHi Yaniv,
Was my suggestion helpful to you? If yes, would you please kindly mark the corresponding reply as an answer?
Best regards,
Yuliana Gu