jeudi 27 avril 2017

Power BI-Custom Column, check if value is date or text

I am trying to add a custom column in the query editor that returns the value of a column if it is a date and null if the value is text.

=if(isdate[Report Due Date]) then [Report Due Date] else null

I get the error message that isdate is not recognized, can someone please tell me the expression to use for this?

Aucun commentaire:

Enregistrer un commentaire