Forum Discussion

Rothbardian's avatar
Rothbardian
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Solved

Creating a measure to return the date after a given date

How do I create a measure or created column identifying the first date occurring in a table after a given critical date?   Scenario Our team assumed responsibility for a large, active body of cont...
Need Help
  • Rothbardian's avatar
    Rothbardian
    5 years ago

    UPDATE: I was able to derive the information I needed through a combination of filters on the Published field and Earliest calculation on the visual values. 

    • Visual filter: Published is on or after 7/1/2020
    • Visual Values field: Earliest(Count (Distinct) of WorkItemID)

    This resulted in a matrix counting first publication of articles after the critical date. 

     

     

    I manually confirmed that each article listed was unique and that the listed publication date was the first after the critical date.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Please share the logic behind generating the dates in the InScope column.

  • Rothbardian's avatar
    Rothbardian
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    Hi Ashish,

    The logic is very straightforward:

    • The InScope date is the first (earliest) date of publication (from Published column) on or after July 1, 2020. The table is refreshed daily from an ADO analytics view.