topic Re: Challenge of Challenges in DAX Commands and Tips

Challenge of Challenges

FrankWoody — Tue, 21 Jun 2022 21:26:37 GMT

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=115462716774578262210&rtpof=true&sd=true

Re: Challenge of Challenges

vapid128 — Tue, 21 Jun 2022 23:30:26 GMT

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.

Re: Challenge of Challenges

FrankWoody — Wed, 22 Jun 2022 00:17:51 GMT

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?

Re: Challenge of Challenges

vapid128 — Wed, 22 Jun 2022 01:13:35 GMT

If you only want to compare 2 tables.

Link those 2 tables by Project_Id and use related function.