Customer Status Changes

[ChristophP]

We have customers that are provided with different statuses. There are different statuses if a customer was active or not. Over time we have all the changes of statuses.

Now comes the problem: we want to show in a list only the customers whose status has changed (to positive or to negative). In this list the customers should appear only once and not with all status changes.

Can you help me with this?

[v-chenwuz-msft]

Hi @ChristophP ,

If there are some index or date column in your table? Or the status of customer will be over written by refreshed rather than add a new row to record the status.

If over written, It is impossible to do that.

if add rows. Adapt the following measure to your model.

Measure = 
VAR _pre =
    CALCULATE(
        MAX( 'Table'[status] ),
        ALL( 'Table' ),
        PREVIOUSMONTH( 'Table'[date] )
    )
VAR _cur =
    MAX( 'Table'[status] )
RETURN
    IF( _cur = _pre, BLANK(), 1 )

Put the measure in filter pane and set show items is 1.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[mh2587]

Customer List = CALCULATE (
    VALUES ( Table1[CUstomer Name] ),
    Table1[CUstomer Name] IN { "Positive", 'Negative' }
)

[ChristophP]

I don't have such a column yet, but I also want the customers to be displayed only once, with summed change over time.

[Anonymous]

@ChristophP 

So tell me about your data along with column name so we can work on it to get the expected result.

[Anonymous]

Hi @ChristophP 

Do you have a list or column which contains status of customers positive or negative ?

if so then u can get it by using Distinct DAX function.