Forum Discussion
Anonymous
5 years agoNot applicable
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
- amitchandakSuper User
Anonymous , Try like
ISBLANK(CALCULATE([mesure], filter(date, date[date] = MIN(date[date]))))