Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.How can that be a possibility?
Thanks
Year-Month Week Numerator
2016-06 23 100
2016-06 24 150
2016-06 25 170
2016-06 26 166
Year-Month Week Denominator
2016-06 23 1000
2016-06 24 1500
2016-06 25 1700
2016-06 26 1660
2016-06 27 1660
Solved! Go to Solution.
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.
What happens if instead of week of year, you put in the week of month?
In doing it that way it will only start from the first date of the month for the first week?
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.
Hi @karkar,
I an unable reproduce your scenario, could you please share your resource data or .pbix file for further analysis?
Best Regards,
Angelia
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |