Is there a way to find out which days my products changed there content?

CMike

New Member
Joined
Dec 19, 2019
Messages
1
Office Version
365, 2019, 2016, 2010
Platform
Windows
I have tried to figure out which product has had it's content changed and on which date it changed.

So far I created to column for the length of the content column because if that changes, the content has changed. And as there are definers for the product such as "ItemNum", "CountryCode" and "Source".

=CALCULATE (
SUM ('TableName'[Content Length] ),
PREVIOUSDAY('TableName'[ReportDate]),
ALLEXCEPT ('TableName', 'TableName'[ItemNum], 'TableName'[countryCode],'TableName'[Source],'TableName'[Available Stock Units]
))


Am I going about this the right way? Is there a better way to figure out if the content of a product has changed or not.

Thank you :D

CMike
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Watch MrExcel Video

Forum statistics

Threads
1,095,748
Messages
5,446,266
Members
405,392
Latest member
Steveoaktree1977

This Week's Hot Topics

Top