Reply
Frequent Visitor
Posts: 11
Registered: ‎08-08-2018

If Date is Blank

Capture.JPG
Hello All,

I am trying to do an if statement where if the date is blank return x,y. 

I have tried using this formula and a few others but cannot get it to work.

IF ( ISBLANK(VALUES(Combined[ClosingDate])), 0 , [ActualGainOnSale] / [FinalAllICosts] )

Any suggestions would be great.

Thanks

 

Highlighted
Community Support Team
Posts: 5,652
Registered: ‎09-21-2016

Re: If Date is Blank

Hi @kstudsrud,

 

Suppose [ActualGainOnSale] and [FinalAllICosts] measures, to create a if statement with a measure, please refer to:

 

Measure =
IF (
    ISBLANK ( SELECTEDVALUE ( Combined[ClosingDate] ) ),
    0,
    [ActualGainOnSale] / [FinalAllICosts]
)


Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.