Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Challenge of Challenges

As noted in worksheet 1, I have some basic information before starting the project:
Project_Id is the ID of each unique project.
Base_date is the project start date.
Data_ProjectEnd is the end date by which the project will be completed.
After saving this project base worksheet in the bi, I need that the next time I update it, it is necessary to compare if the Data_ProjectEnd was changed, in this case, buy if the date before the update is equal to the current date of the Data_ProjectEnd.
If it is the same, no problem, just update the default information.
If it is different I need to show what was the previous date defined and the current date and I need to keep it as many times as they are changed.
If the update brings a new project that is not in the base worksheet, I need to register this new project in the base worksheet for the next consultation.

On Sheet 1 is the Base.
On Sheet 2 it would be a possible update.

I would like to know if it is possible to do this with Bi, and if so what would be the way. The article is almost for a Brainstorm so if you have ideas feel free to write them.
Link to download:

Solution Specialist
Solution Specialist

If you only want to compare 2 tables.


Link those 2 tables by Project_Id and use related function.

View solution in original post

Solution Specialist
Solution Specialist

If you only want to compare 2 tables.


Link those 2 tables by Project_Id and use related function.

Solution Specialist
Solution Specialist

OK, this is not something we can do by make dax functions ONLY.

It need to do the snapshot of the daily data.


The way how to do snapshot, is depands on what is your original date.

If it is in some kind of file, such as CSV or Excel file.

Just name your file name by date.

And import the all files, with the name data. 


the data will be looks like:



and If it is in a datebase , such as mySQL or HIVE.

I would recommend you use dataflow and incremental refresh.

if I add a column with data_date in this case the date that the information was extracted.
I can compare the Project_Id, with that if the project_Id are the same then I will compare the Data_ProjectEnd if they are divergent I can create a condition that displays this divergence correct?

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors