Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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?
     
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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