DAX help with BLANK detection

[Anonymous]

Hi, 

My dataset often has some BLANK fields when going back in time,

I need a DAX condition to detect BLANK fields in my dataset. I don't want to remove them i just need the conditon to integrate further into dax calculations.

see exemple below:

In this exemple, selecting the 01.01.2021 in the interval would trigger the condition because there is no apple sales the 1st. 

I would like something like: ISBLANK(CALCULATE([mesure], date[date] == MIN(date[date]))

But Power BI doesn't accept the 'min' in the condition.

Do you guys have any idea on how to do this ?

[amitchandak · Accepted solution]

@Anonymous , Try like

ISBLANK(CALCULATE([mesure], filter(date, date[date] = MIN(date[date]))))