Forum Discussion

jalaomar's avatar
jalaomar
Helper IV
6 years ago

Count distinct rows after a certain date

Hi all!   I would like to get help on creating a new measure that count distinct rows after a specific date. In a column I have the so called "CI Status" - For the CI status related to the followi...
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

jalaomar ,

 

Your requirement is not clear. Please show sample data and expected result.

 

Regards,

Jimmy Tao

  • jalaomar's avatar
    jalaomar
    Helper IV
    6 years ago

    Hi,

    Currently am working with Cost Poor Quality data and further would like to highlight all Technical issues (TI) and related cost that has been linked to a Consolidated Issue (CI) after its Date: CI Closed.

    Example: If a CI was closed on date 2019-01-01 with a solution then I would like to monitor if new Technical Issues was logged after that date and its related cost.

    Date: CI Closed

    2019-01-01

    2018-06-30

    2017-04-05

    ....

    The Column Date: CI Closed has different dates depending when a solution was in place. I would to monitor all new Technicla issues  and related Cost logged after thoses dates. a technical issue has a occurrence date.

    so the Occurence date should always be after the Date: CI Closed.

     

    is it possible to display values only after Date: CI Closed?

     

    Best regards,

    Jala