Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Display only the first date for status changes only

I need help with a large table that I have. I would like to display only the following columns: ID, TAG, Team, Status and Changed Date. However, I would like to ignore when the TAG changes (and...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous I believe you changed the table and column name in the measure per your model, correct?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k yes, I did. This is what I have:

Measure x =
VAR __m = CALCULATE ( MIN ( 'Test Scripts'[Changed Date]),
ALLEXCEPT ( 'Test Scripts', 'Test Scripts'[Work Item Id], 'Test Scripts'[State] ) )
RETURN IF ( MAX ( 'Test Scripts'[Changed Date] ) == __m, __m )

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    Anonymous so you are adding this as a measure, can you share the screenshot of the error. This all look ok to me.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      parry2k 
      Thanks for that. I added as a measure and it worked perfectly as a measure.
      However, I would like to filter by date using my slicer and unfortunately slicers can't use measures.
      Is there any other way for me to do this?