Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Week Number by Fiscal Year

Hi,   I'm trying to create a calculated colunm that groups dates into one of three values.   Current Week - all dates that are in this month Previous Week- all dates in previous month Historic ...
Need Help
Show and Tell
Tips and Tricks
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    Anonymous 

     

    You may simply use DATEDIFF.

    DATEDIFF ( 'Table'[Date], TODAY (), WEEK )

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi az38,

 

Thanks for responding to this and my earlier post. 

 

I'm pretty much trying to do the same but based on weeknumber instead Month.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    6 years ago

    Anonymous 

     

    You may simply use DATEDIFF.

    DATEDIFF ( 'Table'[Date], TODAY (), WEEK )