cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Etienne_helpplz New Member
New Member

Dynamics rate of change from random period

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 Smiley Happy 

 

Thx a lot

1 REPLY 1
Community Support Team
Community Support Team

Re: Dynamics rate of change from random period

Hi @Etienne_helpplz

 

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.

How to Get Your Question Answered Quickly

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.