Forum Discussion

karkar's avatar
karkar
Helper III
9 years ago
Solved

DATE WEEK

Hello,   I am trying to do a table by Week of Month-Year. Actually two tables-one for numerator and the other for denominator. Unfortunately in the denominator table I am getting some weeks extra....
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Weeks and months don't play nicely when it comes to grouping dates.  As you can see, the first and last weeks start before and extend beyond the month of June 2016.  If you happen to have data in these the week group will be returned.

     

     

     

     

     

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi karkar,

I an unable reproduce your scenario, could you please share your resource data or .pbix file for further analysis?

Best Regards,
Angelia