How to capture change of Text for previous period ?

[Anonymous]

I have 3 columns -  Project number, Status and Month. 

Project	Status	Month
11	PR	Jan-18
11	PR	Feb-18
11	FE	Mar-18
11	FE	Apr-18
11	FE	May-18
11	CD	Jan-18
22	CD	Feb-18
22	PR	Mar-18
22	PR	Apr-18
22	PR	May-18
33	FE	Jan-18
33	FE	Feb-18
33	FE	Mar-18
33	PR	Apr-18
33	PR	May-18

I am trying to find way how to get information about change of status - for example when projects left FE status to PR. 

tried to use Previousmonth but cannot find a way how to use it with text. 

thank you for any help

[v-jiascu-msft]

Hi @Anonymous,

Maybe you can change the type of the [Month] into Date or add a new date column.

DateMonth = DATE(YEAR([Month]), MONTH([Month]), 1)

Then create a date table due to the time intelligence function needs it. 

Finally, you can add a new column to get the status of changes.

Column =
VAR lastStatus =
    CALCULATE (
        MIN ( Table1[Status] ),
        PREVIOUSMONTH ( 'Calendar'[Date] ),
        ALLEXCEPT ( Table1, Table1[Project] )
    )
RETURN
    IF ( ISBLANK ( lastStatus ) || [Status] = lastStatus, "No change", "Changed" )

Best Regards,
Dale

[Anonymous]

I am looking for a specific month for projects when they changed from status PR to anything else.  (table 1 )

I converted status PR as number 1, everything else is 0. (table 2 )

calculated measure difference between months, so now where is 1 in table 3 i need to count those per month.

what would be the measure for this to calculate how many times there is 1 per month ?

thank you

[v-jiascu-msft]

Hi @Anonymous,

Seems you already have it. Please refer to the snapshot below.

Best Regards,
Dale

[LivioLanzo]

What are you trying to show exactly? The first date of a certain project?

[Anonymous]

im trying to get information :

e.g. project XX changed status from FE to PR on Dec 2018, XY from CD to CB on Nov 2018

was trying to get  value for each row for previous month

[LivioLanzo]

what about showing it on a Timeline visual?