Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello guys, Im stuck on this and need some support.
So I have this table, this is what the team are adding as their target and they pick their own period.
You can see on Date From and Date To the team can decide their targets from what ever date they want.
Product | Target | DateFrom | DateTo | Year | Period |
A | 20 | 1-Nov | 30-Nov | 2022 | 1 |
B | 50 | 1-Nov | 30-Nov | 2022 | 1 |
C | 30 | 1-Nov | 30-Nov | 2022 | 1 |
A | 50 | 1-Dec | 31-Dec | 2022 | 2 |
B | 66 | 1-Dec | 31-Dec | 2022 | 2 |
C | 55 | 1-Dec | 31-Dec | 2022 | 2 |
So I have a table called Date which is my Date Table using Calendar Auto. The one i got stuck is how to add a period column that correlate to the one above. Example in my Date Table, if the row date is 11/2 that means its Period 1 (which is based on the table above)
Not sure if this is the right approach, if you guys have any good idea. please guide me to the right direction 🙂
Date Table | |
Date | Period |
1-Nov | |
2-Nov | |
3-Nov | |
4-Nov | |
5-Nov | |
6-Nov | |
7-Nov | |
8-Nov | |
9-Nov | |
10-Nov | |
11-Nov | |
12-Nov |
@ChristianDGreat , refer if these two approaches can help
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |