CODEWITHSUNDEEP
dateif-statementpowerbi
Bad_Mama_Jama
Bad_Mama_Jama

Reputation: 196

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?

Upvotes: 3

Views: 11858

Answers (1)

Sergey Lossev
Sergey Lossev

Reputation: 1530

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

Upvotes: 6

Related Questions