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)

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I also should mention that I have no ability to manipulate the data at the database level. I can only use the functionality limited to live dataset connections. 

v-diye-msft's avatar
v-diye-msft
Community Support
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)