IF Dax coding

[eilidh3]

I'm fairly new to DAX coding so appologies if this is quite a simple one...

I'm looking to show a value if a date field contains data and show as £0 if the date field doesnt contain data. 

Example below.

Business Name	Delivery Date	Value
North	01/01/2020	£5
East		£10
South	02/02/2020	£15
West		£20

Thanks

[Greg_Deckler · Accepted solution]

Column = IF(NOT(ISBLANK([Delivery Date])),[Value],0)

[V-lianl-msft · Accepted solution]

Hi @eilidh3 ,

Please make sure that [delivery date] is in date format, you can try to create a calculated column or measure.

Measure = IF(NOT(ISBLANK(MAX([Delivery Date]))),MAX('Table'[Value]),0)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

Column = IF(NOT(ISBLANK([Delivery Date])),[Value],0)