Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to Solution.
@Anonymous , Try like
ISBLANK(CALCULATE([mesure], filter(date, date[date] = MIN(date[date]))))
@Anonymous , Try like
ISBLANK(CALCULATE([mesure], filter(date, date[date] = MIN(date[date]))))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |