Forum Discussion

vignesh21's avatar
vignesh21
Frequent Visitor
8 years ago
Solved

powerbi

what is the equivalent of isdate in powerbi.

I need to check whether a field is date while creating a new column in powerbi.

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi vignesh21,

     

    You should check the date type in Power Query with ThomasDaviesMCR's suggestion.

     

    Best regards,

    Yuliana Gu

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    datecheck = if('Table'[Column] is date) then "yes" else "no"

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi vignesh21,

     

    You should check the date type in Power Query with ThomasDaviesMCR's suggestion.

     

    Best regards,

    Yuliana Gu