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.
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 :
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
It seems you may refer to this post.Sample data and expected output will be helpful to provide an accurate solution.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.