Forum Discussion
Completed Per Week
Hi, I am currently trying to work out how to calculate number of completed jobs per week, I have the following formula No. Jobs Completed = CALCULATE( COUNTROWS('Job Tracker'), FILTE...
Hi SmartZ96,
Do you have a date dimension table in your data model, with week related columns in it? If not, I would look into that. It would make this infinitely easier.
This is the most comprehensive date dimension table I've come across so far.
----------------------------------
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.