Help creating new column depending Date column

[Anonymous]

Hi all,

I need to create a new column due to the following scenario:

At the end is to move the cuantities one month less in the Sales Date. I was trying with Lookupvalue but it didn't work.

I hope you can help me thanks.

[amitchandak · Accepted solution]

@romero01 , Try

sumx(filter( Table, [Product]-earlier([Product]) && [Customer]-earlier([Customer]) && [StockDate]-earlier([SalesDate] ),[ventas])

O
sumx(filter( Table, [Product]-earlier([Product]) && [Customer]-earlier([Customer]) && [SalesDate]-earlier([StockDate] ),[ventas])

[Anonymous]

Hi @Greg_Deckler  I was testing the qurey but seems is saying to me that the parameter is not correct type.

Hi @amitchandak I think we are close 🙂 but only is showing one result or maybe only is taking the first one. 

Attached the link with the powerbi document. Whith both querys.

https://t2cspain-my.sharepoint.com/:u:/g/personal/cromero_t2client_com/EbH-iRo4w3hPluWNiQR2YYcB2V2uv...

I hope yu can help me thanks.

[v-yiruan-msft]

Hi @Anonymous ,

Could you please provide the correct value of field [WhatIWant] base on your current sample data and the calculation logic? Thank you.

Best Regards

Rena

[Anonymous]

Hi @Greg_Deckler  any tip about this topic?

Hi @amitchandak  any tip about this topic?

[Greg_Deckler]

@Anonymous I had a syntax error, maybe:

What I Want =
  MAXX(
    FILTER(
      'Table',
      [Product]=EARLIER([Product]) &&
        [StockDate]=EARLIER([SalesDate]) &&
          [Customer]=EARLIER([Customer])
    ),
    [Stock]
  )

[Greg_Deckler]

@Anonymous Maybe:

What I Want =
  MAXX(FILTER('Table',[Product]=EARLIER([Product])&&[StockDate]=EARLIER([SalesDate]&&[Customer]=EARLIER([Customer])),[Stock])