Forum Discussion

ChristophP's avatar
ChristophP
New Member
4 years ago

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 wa...
Need Help
Tips and Tricks
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

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.