Date format column with in some cases "#" values

[Novice_PBI]

I have a table with field dates, but in some cases the field has "#" values, so when I try to format the field as a date I got an error message because some "#" values, I can't modify the # Values because in cases the # values means the date is not defined yet. How can I format the column as a date?

[Anonymous]

HI @Novice_PBI ,

I'm not so recommend you to use specific character as fields name, it will faced some issue when power query function processing these fields.

In my opinion, I'd like to suggest rename these fields who has specific character before use them in query functions and restore these fields after finish the operations.

Regards,

Xiaoxin Sheng

[Novice_PBI]

Hi @Anonymous, when I mention '#' values I mean some cells with '#' values, not the name of the field, in that cases

Do you recommend to changes the cells for a date to format the column as a date?

[Anonymous · Accepted solution]

Hi @Novice_PBI ,

Character "#" is the character escape, you can take a look at following blog to know more about this.

Character Escape Sequences In M

You can replace these "#" value as null or other specified date to prevent format issues.

Regards,

Xiaoxin Sheng