Comparing Data status of job in different versions

[shahinnakhai]

Hello,

I have data set for job status of a company. My data include version column position ID and status of those position (open and filled) beginning date fiscal period etc. Each position ID is unique. Each month new version will be added to our data.
I want to be able to compare each version to another and see if the status of the job changed between those jobs and list those jobs that their status changed from Open to Filled and vice versa. Also list new jobs which exist in one version but not on the other one.
I am using Direct Query. you can find part of my data set header. New version will add in each column.

I really appreciate your help.
Shahin

[v-eachen-msft]

Hi @shahinnakhai ,

You could use RANKX() function to create a rank column based on the column you have group to sort your data.
Then get the data of previous version with EARLIER() function and compare them.
You could refer to this sloved case:

https://community.powerbi.com/t5/Desktop/DAX-getting-previous-value/m-p/489921

[shahinnakhai]

Thank you for your response. I think that is totally different with what I am looking for.

Here is an example 

I want to be able to compare different Version's PositionID and see the change on it. Also I have more than two version and I want to be able to choose for example version 1 with 2 or version 1 to 5 or 2 to 6 and so on. I want to be able to pick versions and see comparison resault on the report.

Best,

Shahin