Forum Discussion

Dreamer_Argento's avatar
Dreamer_Argento
Helper I
2 years ago
Solved

Null values in segmentation

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 'betwe...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.