I want to extract change of status.

[Eiji77]

I have two tables. Last month and this month.

The status changes from A to B, C.

I want to extract what is C this month, not C last month.

Do not count what was already C last month.

What should I do now?

[Anonymous]

Hi @Eiji77

Can your share more details about data model ? Do you have a Calendar Table ? WHat are the additional columns in the two tables ?

Cheers

CheenuSing

[Eiji77]

Thank you CheenuSing.

The details of the table look like this.

I have a calendar table.

[v-lili6-msft · Accepted solution]

HI, @Eiji77

    After my test, you do these like below:

Assume these are two table

last month

this month

Step1:

create the relationship between them

Step2:

Create a table to extract what is C this month, not C last month.

Table = FILTER('this month','this month'[Status]="C"&&RELATED('Last month'[Status])<>"C")

Result:

here is pbix, please try it.

https://www.dropbox.com/s/5pt9o8l58z0ux7d/extract%20change%20of%20status.pbix?dl=0

If it is not your case, please share your sample pbix for us. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading

Best Regards,

Lin

[Eiji77]

Thank you @v-lili6-msft !

solved!