Forum Discussion

AndrewUrban's avatar
AndrewUrban
Frequent Visitor
4 years ago
Solved

Trended Weeks over Prior Period Help

Hello!    I'm hoping someone can help me write a DAX statement for a prior period (latest 12, 26, 52 weeks) which I'd like to then turn into a % chg. I have weekly data now which i've created trend...
  • AndrewUrban's avatar
    AndrewUrban
    4 years ago

    This is fantastic! I think I can figure out the rest from here, thank you so much for breaking this down. 

     

ManguilibeKAO's avatar
ManguilibeKAO
Icon for Resolver I rankResolver I
4 years ago

Hi AndrewUrban,

 

Coud you show the tables in your data model?

 

Best regards.

AndrewUrban's avatar
AndrewUrban
Frequent Visitor
4 years ago

Hi,

 

Thanks for the reply, see below for my "Date" table: