Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Splitting Date information into weeks

Hello,   I'm having an issue with splitting date time into weeks. I'm unsure of how to accomplish this given the fact that I am using a live dataset connection. I guess the underlying question is h...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    For the live-connection mode, you can add the weeknum using the measure below:

    Measure 2 = WEEKNUM(MAX(Table1[Date]),2)

     

amitchandak's avatar
amitchandak
Super User
6 years ago

In case you are using a direct query. Then preferably have your date calendar in the database and have weeks define in the database. In case you using the data import, then create a date calendar table wen define week with help of week no

 

Week = "Week " & weeknum(date[date])

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin