Forum Discussion

Memphis28's avatar
Memphis28
Frequent Visitor
2 years ago

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 si...
Dynamic Dates
Percenatage
Memphis28's avatar
Memphis28
Frequent Visitor
2 years ago

Afternoon
I haven't had chances to try this suggestion yet, i will do as soon as i can and report back.
I did figure a quick and dirty way of getting some of what i needed but it isn't the final solution. I created two measures, one that found the Value on the FIRSTDATE in the Date table and one that found the LASTDATE in the date table and then wrote a 3rd measure to DIVIDE the two. Not elegent or efficient but it worked on the day.

 



PercentSlicerDiffMin = CALCULATE(COUNTA(TeamJ[CASE_ID]), FIRSTDATE(TeamJ[Date of Report]))

 

PercentSlicerDiffMin = CALCULATE(COUNTA(TeamJ[CASE_ID]), LASTDATE(TeamJ[Date of Report]))

PercentDivide = DIVIDE([PercentSlicerDiffMin]-[PercentSlicerDiffMax],[PercentSlicerDiffMax],0)
 
 
I still need a better solution that wll show the changes in a table so i will try and pull some sample data and a streamlined version of PBIX later today and share with you.
Again, the help is appreciated. Thank you