How to compute duration for stock not moving ?

[Paulyeo11]

Hi All

https://www.dropbox.com/s/t9jgm1kdncrpb1p/Ask%20how%20to%20compute%20stock%20not%20move%20period%20V...

[amitchandak · Accepted solution]

@Paulyeo11 , Try like, You can use AverageX in place sumx

Measure = sumx(values(INVC[Long desc]),CALCULATE(DATEDIFF(max(INVC[DATE_MOVE]),TODAY(),DAY)))

File attached after signature

[Anonymous · Accepted solution]

@Paulyeo11 Please create a column as below and add it to the visual- 

Column = DATEDIFF(INVC[DATE_MOVE],TODAY(),DAY)

[Anonymous · Accepted solution]

@Paulyeo11 Please create a column as below and add it to the visual- 

Column = DATEDIFF(INVC[DATE_MOVE],TODAY(),DAY)

[Paulyeo11]

Hi Nikh

When i try to implement the shorter expression , i am not able to locate Date field.

[Anonymous · Accepted solution]

You need to create column not measure

[Paulyeo11]

Hi Nikhi

Your script is shorter.

Thank 

Paul

[amitchandak · Accepted solution]

@Paulyeo11 , Try like, You can use AverageX in place sumx

Measure = sumx(values(INVC[Long desc]),CALCULATE(DATEDIFF(max(INVC[DATE_MOVE]),TODAY(),DAY)))

File attached after signature