How Can I do this if statement as a measure in power bi

[ligalbert]

I want to create a measure to do a new column which creates IF PaidOffDate is blank then LoanAmount is blank otherwise LoanAmount is the same Value. I have posted of the desired result on that i got on excel 

 

 

 

[v-kkf-msft]

Hi @ligalbert ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please try the measure.

Measure =
IF (
    MAX ( 'Table'[PaidOffDate] ) = BLANK (),
    BLANK (),
    SUM ( 'Table'[LoanAmount] )
)

Best Regards,
Winniz

[PabloDeheza · Accepted solution]

Hi @ligalbert !
Try the following:
IF( PaidOffDate = BLANK(), BLANK(), LoanAmount )
Considering PaidOffDate is a measure.
Let me know if that helps!