New 'Yes/No' column depending on changes to a value associated with an ID

[Dominok123]

Hey guys,

I am struggling with trying and getting the third column 'Change' (in the table below) working in Power BI. 

Basically I need to work out if the value column has changed two or more times for each ID. So values that change once within the same ID would not count - only if the value changes 2 or more times per each ID.

In the table below you see that:

ID 1 value changed twice so that = 'Yes'

ID 2 did not change = 'No'

ID 3 value changed once so that = 'Yes'

Any help would be much appreciated.

Table1:

ID	Value	Change
1	1000	Yes
1	1000
1	1200
1	1800
2	720	No
2	720
3	900	No
3	900
3	1000

[Zubair_Muhammad]

@Dominok123 

So you can count distinct values per each ID and if they are greater than 2...answer should be "yes"...

Isn't it?

[Dominok123]

Yeah, I just have no idea how to do it even though this should be really basic. Like I have no idea what the DAX formula for this would be.

[Zubair_Muhammad · Accepted solution]

@Dominok123 

You can use this calculated column

Column =
IF (
    CALCULATE ( DISTINCTCOUNT ( Table1[Value] ), ALLEXCEPT ( Table1, Table1[ID] ) ) > 2,
    "yes",
    "no"
)