Null values in segmentation

[Dreamer_Argento]

I have a segmentation set up in 'between' mode on a date field. I want to be able to filter out some records from the table, but the segmentation does not display null values when it is set to 'between' mode.

[Anonymous]

Hi @Dreamer_Argento ,

Has your problem been solved? If so, please mark the correct answer.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Dreamer_Argento ,

When using segments in ‘between’ mode on date fields, you must consider how to handle null values. By default, the ‘between’ mode takes two parameters: a start date and an end date. However, null values are not considered valid dates, which is why they do not appear in segments.

Create custom metrics or calculated columns that explicitly handle null values.

flag = IF('Table'[Date] = BLANK() , 0 , 1 )

Below is my table:

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.