Forum Discussion

SianM's avatar
SianM
Frequent Visitor
8 years ago
Solved

Multiple Sorting and Calculating from previous row

Hi All,   I am trying to track the occurance of a particular status in my data set over time (per unique ID).    I have been reading a few pages and am worried it is not possible to do what I am ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi SianM,

 

Based on my analysis, in DAX, you can create a calculate column and use formula like this pattern:

Count Closeout =
IF (
    CALCULATE (
        COUNTROWS ( Table[Milestones Status] ),
        FILTER (
            Table,
            Table[Lease ID] = EARLIER ( Table[Lease ID] )
                && Table[Milestones Status] <> EARLIER ( Table[Milestones Status] )
        )
    )
        <> 0,
    1,
    0
)

Regards,

Jimmy Tao