If value in column have date then all other values to be blank

[ademerdash]

Hi,

I have values in column with dates in other column, I need if certain value have date then all other values dates to be blank.

Example, I need to create matrix show stages and once a stage have date the previous stages to be blank to count last stage.

[Anonymous]

Hi @ademerdash ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create a measure

Measure = 
VAR _PERIOD=
CALCULATE(
    MAX('Table'[Period]),
    FILTER(
        ALLEXCEPT(
            'Table',
            'Table'[Name]
        ),
        'Table'[Date] <> BLANK()
    )
)
RETURN
IF(
    SELECTEDVALUE('Table'[Period]) = _PERIOD,
    SELECTEDVALUE('Table'[Date]),
    BLANK()
)

Final output

Best regards,
Albert He

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

[ademerdash]

Thanks Albert,

The issue that I do not have period methodology to structure the date events, I have sequance events steps with different dates, I need the formula to run with only 2 logics (steps vs dates) is it possible, I tried to create column and change the steps to sequance 1,2,3 and not works.

[Anonymous]

Hi @ademerdash ,
Thanks for the reply, without a column like (Name) to measure against, you can only get the last date under each step, not up to the result you want to blank. The step, name and date will all be used as criteria for filtering. If you can, please provide detailed example data so we can help you faster. Please hide sensitive information in advance.

Best regards,
Albert He

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