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
kleedt's avatar
kleedt
Frequent Visitor
3 years ago

Hi Uspace87 ,

 

thanks for the quick reply.

 

[Date] is part of the same table as [promotionStatus] and [EAN].

 

I created a date table and linked it to DIM table, but now the "Promo Status previous day" measure either produces an empty table or, if I create it as calculated column instead of measure, an empty column.

  • Uspace87's avatar
    Uspace87
    Resolver III
    3 years ago

    if you have already a Dim Date Table just link the DateKey to Date into your Fact table.

     

    Check if the dates are correctly formatted in both tables. It should work