Percentage difference between dynamic date range
Afternoon I have had a look on the forum and, depsite the wealth of knoweldge i can't seem to find the answer to my issue so hoping someone can point me in the right direction. I think it is a simple ask but i am relatively new and can't seem to get my head around it. I want to create a measure that will calculate the percentage difference between two values (this will be a total count value of cases/tickets). I want to be be able to change the date range using a slicer and have the percentage dynamically change wiht it. So case count on the MIN date is first value and the case count on the MAX date is the second value. I tried using the quick measures tool but it forces your hand in to choosing a specific date as you can see below. Is there a way to adapt to function code to make it dynamic? The outcome being two things, a scorecard that shows the percentage difference between the date range (as selcetd by a slicer) and a table with the date of each report and the difference between the MIN date and the date of the report (see bottom screen shot) I am keen to learn so any guidance on how to do it but also why it is done that way is hugely appreciated. Count of CASE_ID % difference from 27 October 2023 = VAR __BASELINE_VALUE = CALCULATE( COUNTA('TeamJ'[CASE_ID]), 'TeamJ'[Date of Report] IN { DATE(2023, 10, 27) } ) VAR __MEASURE_VALUE = COUNTA('TeamJ'[CASE_ID]) RETURN IF( NOT ISBLANK(__MEASURE_VALUE), DIVIDE(__MEASURE_VALUE - __BASELINE_VALUE, __BASELINE_VALUE) ) Below is showing the differnece from the 27th of Oct no matter the date selected using the slicer. FYI the slicer uses the date of the report data
