Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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