CODEWITHSUNDEEP
dynamicpowerbidax
Darko Milic
Darko Milic

Reputation: 189

DAX query for DATEVALUE

I have DAX Query and need to assign DATEVALUE to column in IF clause.

    Invoice_Date :=
IF (
    FactCustTrans[DOCUMENTDATE]=DATEVALUE ( "1/1/1900" ),
    FactCustTrans[TRANSDATE],
    FactCustTrans[DOCUMENTDATE]
)

Error is The syntax for '=' is not correct

Upvotes: 0

Views: 465

Answers (1)

James Hamilton
James Hamilton

Reputation: 51

Try the DATE function ( YYYY, MM, DD )

    Invoice_Date :=
IF (
    FactCustTrans[DOCUMENTDATE]= DATE ( 1900,1,1 ),
    FactCustTrans[TRANSDATE],
    FactCustTrans[DOCUMENTDATE]
)

Upvotes: 1

Related Questions