Forum Discussion

kleedt's avatar
kleedt
Frequent Visitor
3 years ago

Get value for previous day for a string

Hello,   I have a column [promotionStatus] indicating for each day ([Date]) whether a product ([EAN])is on promotion or not.   I now want to create a measure with [promoStatus] value of the previ...
Need Help
Uspace87's avatar
Uspace87
Resolver III
3 years ago

 

kleedt's avatar
kleedt
Frequent Visitor
3 years ago

Uspace87 

When I use Date and Dim tabel with established connection on date key, no rows are skipped. However, the measure is not giving output as expected (see below). I have not changed the measure, other than referencing Date tabel in DATEADD part of the measure.