Forum Discussion
Calculating daily difference on network throughput
In your world, what is a week? What is a quarter? Do you have a Calendar table that identifies the boundaries?
Do you want to show the thoughput change just week over week, or week over week to date?
your second sample file is not accessible.
I do have a calendar table where my weeks and quarters are defined, and it is based on a normal year - 1st January to 31st December with the normal 4 quarters.
The week over week should be based on the week numbers in this calendar (again, based on a normal calendar year) - not week over week to date.
I noticed the sharing somehow was changed - here is the new link: https://docs.google.com/spreadsheets/d/1ak1Z0R40uDlLFEL9JvpWaWzfoRx1qKlCrwAD6KX9ahY/edit?usp=sharing
please post your week logic, and describe what should happen between December and January.
Also refer here https://www.daxpatterns.com/standard-time-related-calculations/
My week logic is based on this DAX code:
Date = addcolumns(Calendar( Date(2020, 1, 1), Date(2021,12,31)), "weeknum", weeknum ( [Date] ))and colums:
Month = Format('Date'[Date], "MMM yyyy")Quarter = Year('Date'[Date]) & "-Q" & Format('Date'[Date], "q")Year = Format('Date'[Date], "yyyy")MonthSort = Format('Date'[Date], "yyyy-mm")As for December to January, it should loop, so week over week I expect it to do week 1 over week 52, and then week 2 over week 1, etc. Am I understanding this principle correctly?Hi lbendlin , I'm curious to know if you have managed to look at the data and were able to generate a view for the week over week data?
I'm still not having any luck generating the view, so I would really appreciate your help to guide me into the right direction for this