Forum Discussion
Transforming Data
Hi, I am looking for some advice. I want to be able to transform data that looks like this: Building Date Task Status Building 1 Lock Doors 01/01/2020 Done ...
Hi,
I don't see where you would get the current dates from in the upper table. Can you not add them in your data source and then import it to Excel? Without any consistent pattern in those dates I don't think PBI is the right tool to add another column to your dataset.
Regards,
Jasper
Hi Anonymous
That is part of the problem I would need (somehow) to be able to idenity the current date based on the last date entry for a sepcific task that relates to a building.
Thanks,