Hi all,
I have an issue because I would like to make a more sophisticated rate of change than from the last week, the last year or the last month. Dynamic's one
I would be veryyyy grateful if you can help me.
I would like the user can choose a specific period in date segment and get a rate of change of the same number of days in the past.
For example : If the user is focus on a week that would be the previous week (same for months or years), BUT if this user is focus on 10 days, I want to make a rate between that days and the 10 previous days... etc
My other issue is that I have others segments/filter on my report and all are not present everydays on my table. So if one event happen only two time on a week and I use fonctions like DATESBETWEEN, I got 2 days instead of 7 days. Do you know how can I catch the min and max filters dates ?
So all my issue it's how get the period that are on the filters (no matters if I have row or not on my event table after other filter actived) and look at the same period previously with the filter activated.
Table 1
A = Columns Date
B = Id -> my metric distinct (Id)
C = Columns Event N°1
D = Columns Event N°2
That would be something more complicated that :
DATEADD(
MIN( 'Table 1 '[Date] ) ;
COUNTROWS ( DATESBETWEEN ( 'Table 1 '[Date] ; Min ( 'Table 1 '[Date] ) ; Max ( 'Table 1 '[Date] ) * - 1
; DAY )
It's been 3 days since I have been dealing with. And sorry for my english 🙂
Thx a lot
