Articleprice changed

[wunderch]

Hi guys,

I have the following problem:

I have a table with Date, Article, Price regular and Price supply. (like xlsx)

Now I want to get only Article shown in a table, who have the same "Price supply" since more then 55 days. (like Article 1234)

How can I get this? With Script or Expression in the table?

Please help, I'm frustrated!

Regards

Christian

[antoniotiman]

Hi Christian,

You can try

Only({<Date={'>=$(=Date(Today()-55))'}>} [Price supply])

Regards,

Antonio

[micheledenardi]

I've create a new field that count how many times the Price Supply is equal to its previous record and it works fine:

MainTable:
LOAD Date, 
     Article, 
     [Price regular], 
     [Price supply],
     if(peek([Price supply])=[Price supply],peek(Count)+1,1) as Count
FROM
[Price regular vs Price supply.xlsx](ooxml, embedded labels, table is Tabelle1);

[ahaahaaha · Accepted solution]

Hi,

May be like this

If(Count(Aggr(DISTINCT Sum({<Date={">=$(=Date(Max(Total <Article> Date)-55))"}>} [Price supply]), Article, [Price supply]) )=1, [Price supply])

Example at attached file.

Regards,

Andrey

[wunderch]

Hi Andrey,

that's it.

Thanks for your quick answer.

Regards,

Christian

[ahaahaaha]

Was glad to help you

Regards,

Andrey