Hello everyone - I'm looking for some support with a DAX problem.
I have a table of results showing project details taken at various points in time (e.g. Project ID, Site Code, Start Date, Value), and the intention of the report I'm building is to measure any changes which have occurred between two points in time.
My data has an 'export date' field of when the data was taken, and so far I've successfully create a report which allows two dates to be selected using slicers then produces a table of results showing the changes which have occurred along with a descriptive categorisation (i.e. New Project Created, Project Removed, Start Date Change, Value Change).
Although this achieves my initial goal of measuring the changes, all the results are shown individually in a table view and what I also need to be able to do is present a dashboard view that answers more high level questions such as 'How many projects were delayed?' and 'How many projects have been added?'.
So far the only way I've found of achieving this is to create a summarized table and then recreate the categorisation measure as a calculated column, however the main limitation of this appears to be that I can only use static dates, and not the slicer selections.
The below link includes a crude mockup of the PBIX that I'm working on.
Link: Categorising Variances PBIX
Any support that anyone can offer would be warmly welcomed 😊
