Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX help with BLANK detection

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 ?

  • Anonymous , Try like

     

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

1 Reply

  • Anonymous , Try like

     

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