Forum Discussion
Solved
How to manage date field with null values
Hi Team, I am very new in Power BI. I need to create a calculated column where I am comparing two date fields eg. date1<= date2. date1 has null values and it is passing the condition. What is the...
This is one of those gotcha moments. DAX still evaluates the comparison to resolve the return type, and you end up seeing FALSE instead of BLANK(). A more fool proof way to do the comparison is by creating a custom column in the query editor.
if [Date1] = null then null else [Date1] < [Date2]Vs has this formula and we should expect for it to return blank if Custom is blank but alas it won't once the data type is changed to true/false
v-prasare
Community Support
Community SupportHi @Soumeli,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support