Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
FrankWoody
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: 
https://docs.google.com/spreadsheets/d/1LOyQjTlB6HOPfhhpjM97ODMRntB5g9nU/edit?usp=sharing&ouid=11546...

1 ACCEPTED SOLUTION
vapid128
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

3 REPLIES 3
vapid128
Solution Specialist
Solution Specialist

If you only want to compare 2 tables.

 

Link those 2 tables by Project_Id and use related function.

vapid128
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:

vapid128_0-1655853974513.png

 

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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.