Forum Discussion

mkaol's avatar
mkaol
Frequent Visitor
1 year ago

Calculating weekly running sum

Hello, my semantic model has the following structure: In the fact table FACT_REVENUE, for each snapshot_date/departure_date combination there is a revenue value. It has full revenue value onl...
"Running Total"
DAX
semantic model
Wilson_'s avatar
Wilson_
Memorable Member
1 year ago

Hi mkaol,

 

The simplest solution is to make sure your date table also has a week number column. Standard DAX is notoriously cumbersome with a lot of time intelligence functionality that becomes a lot simpler once you incorporate more columns into your date table.

 

Check out Brian Julius' awesome LinkedIn post for more details.

 

And of course, if you still need more help, please feel free to let me know where you're stuck and I'd be more than happy to assist. 😄


----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

 

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.