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.

Rothbardian's avatar
Rothbardian
Icon for Microsoft Employee rankMicrosoft Employee
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.