Forum Discussion

cjgreene's avatar
cjgreene
Regular Visitor
2 years ago
Solved

Create a dynamic column/measure/parameter based on date slicer

I have a dataset that stores information about cases and when they completed assessments: case_id   assessment_ended 1 1/1/23 1 1/4/23 1 1/6/23   Using a column, measure, or...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi cjgreene 

     

    My Date table sample:

     

    You can create a measure as follows.

     

    Indicator = 
IF (
    SELECTEDVALUE ( 'Table'[assessment_ended] ) > MIN ( 'Date'[Date] )
        && SELECTEDVALUE ( 'Table'[assessment_ended] ) = MAX ( 'Date'[Date] ) - 1,
    1,
    0
)

     

     

     

    Is this the result you expect?

     

    Best Regards,
    Community Support Team _Yuliax

     

    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 cjgreene 

 

My Date table sample:

 

You can create a measure as follows.

 

Indicator = 
IF (
    SELECTEDVALUE ( 'Table'[assessment_ended] ) > MIN ( 'Date'[Date] )
        && SELECTEDVALUE ( 'Table'[assessment_ended] ) = MAX ( 'Date'[Date] ) - 1,
    1,
    0
)

 

 

 

Is this the result you expect?

 

Best Regards,
Community Support Team _Yuliax

 

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