Forum Discussion
Customer Status Changes
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?
5 Replies
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.
I don't have such a column yet, but I also want the customers to be displayed only once, with summed change over time.
So tell me about your data along with column name so we can work on it to get the expected result.
Customer List = CALCULATE (
VALUES ( Table1[CUstomer Name] ),
Table1[CUstomer Name] IN { "Positive", 'Negative' }
)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.
