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
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