Forum Discussion
Calculating daily difference on network throughput
Hi all, We're using Power BI for something different than what it normally is used for - network analysis. The principle of course stay the same. My issue is that I have multiple countries, w...
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