Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
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
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
69 | |
57 | |
37 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |