Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Performance : calculating Moving average, percentile

Good morning, everyone, I would like to present to you a case where performance is poor. The context is this: a date dimension table (this one includes all dates with hh:mm:ss) + a fact table ("PDJ...
Need Help
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    Can you try changing the last 2 bits:

     

    'Fact'[TimeID] >= MovingWindowStart
    && 'Fact'[TimeID] <= MovingWindowEnd

     

    to

     

    'DimTime'[TimeKey] >= MovingWindowStart
    && 'DimTime'[TimeKey] <= MovingWindowEnd

     

    In addition, make sure TimeKey should be an integer.

AkhilAshok's avatar
AkhilAshok
Icon for Solution Sage rankSolution Sage
7 years ago

Can you try changing the last 2 bits:

 

'Fact'[TimeID] >= MovingWindowStart
&& 'Fact'[TimeID] <= MovingWindowEnd

 

to

 

'DimTime'[TimeKey] >= MovingWindowStart
&& 'DimTime'[TimeKey] <= MovingWindowEnd

 

In addition, make sure TimeKey should be an integer.

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

Does that make sense? Kindly mark the answer to close the case. Thanks in advance.

 

Regards,

Frank