Hi Enterprise DNA Team,
I am working on a scenerio where I have multiple date columns and I need to use a slicer to filter by 2 of the dates. For the date range a user has selected , the Avg SLA has to be calculated accordingly. Since I can have only 1 active date relationship at a time , I tried using the Userelationship function but it doesnt give me expected results and throws an ambiguity error.
Attaching pbix file and the input file for your reference.
I have an active realtionship with Date1 and its used as another filter. Date2 and Date3 have inactive relationships with Date table.
When a date range of Jan 2019 is selected only application nos 1,3,4 should be considered for the average calculation as the Date2 and Date3 are within the selected date range.
Also I have couple of other dates like Date4,Date5,Date6,Date7 and Date8 in the same table and I need to find the Average SLA between each of them. What would be the optimised way to do this sort of calcuation and which would be the best visual to represent the same.
Thanks in advance.