How to leave the data calculated blank in the same row by showing only the date defined

[Chanleakna123]

HI all , 

i have code 750 as CO2 10L , this one i should leave it blank , as it doesn't have to be calculated as Expired date or Expired In ( Days ) but when i do column calculated CO2 10L also included in the calculated. is there any way that i can leave the column to be blank  ? only show the QTY , 

PS: Expired In Days and Date of Dispatch calculated from Current date too. 

thx

[v-jiascu-msft · Accepted solution]

Hi @Chanleakna123,

You can add an if statement. For example, if the condition is the Code, you can do it like this.

Measure = if(min('Table'[Code]) = 750, blank(), [Your formula])

If you want more detailed formula, please specify the conditions when to leave it blank.

Best Regards,

Dale

[Chanleakna123]

@v-jiascu-msft , Thanks you so much , it works well .