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 ...
Boycie92 , Your data is not relating to the first table.
Usually in dax new column , you can get previous status and date like
previous date = maxx(filter(Table, [Building] =earlier([Building]) && [Date] <earlier([date])),[Date])
previous Status= maxx(filter(Table, [Building] =earlier([Building]) && [Date] = earlier([previous date])),[Status])