Forum Discussion

jdwalker5's avatar
jdwalker5
Icon for Helper II rankHelper II
2 years ago
Solved

Rolling 4 Week Total

Hello,   I'm trying to get a rolling 4 week total for each row in a summarized table.  Example below with expected result. Week Item Total Rolling 4 Week Total 8 A 5 50 7 A 10...
Need Help
  • jdwalker5's avatar
    jdwalker5
    Icon for Helper II rankHelper II
    2 years ago

    Thanks ThxAlot!  I didn't realize window functions were available in DAX, but that is really good to know.  I played around with it some, but couldn't quite get it to work.  That's probably on me for missing something in the syntax.  I ended up using a SQL window function and brought in a new dataset.  Thanks again for your reply!