Forum Discussion

spb's avatar
spb
Frequent Visitor
4 years ago
Solved

Count new dates only

First time submitting query, so here goes.. Attempting to count when an Actual Start Date first appears in the data for each Activity.  See snapshot of the data per image below. I am looking to be...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    4 years ago

    Hi spb ,

     

    Please try following DAX to create a new column:

    count new starts = 
var _count =
CALCULATE(
    COUNT([Actual Start Date]),
    FILTER(
        'Sheet11',
       [Reporting period end] <= EARLIER('Sheet11'[Reporting period end])
        && [Actual Start Date]=EARLIER('Sheet11'[Actual Start Date])
    )
)
var _if = IF(_count = 1,1)
return _if

    Create a table visual, you will get result you want:

    Best regards,

    Yadong Fang

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

     

v-yadongf-msft's avatar
v-yadongf-msft
Community Support
4 years ago

Hi spb ,

 

Please try following DAX to create a new column:

count new starts = 
var _count =
CALCULATE(
    COUNT([Actual Start Date]),
    FILTER(
        'Sheet11',
       [Reporting period end] <= EARLIER('Sheet11'[Reporting period end])
        && [Actual Start Date]=EARLIER('Sheet11'[Actual Start Date])
    )
)
var _if = IF(_count = 1,1)
return _if

Create a table visual, you will get result you want:

Best regards,

Yadong Fang

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