Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
All,
I need some help cause I am stuck since last Friday.
I have two tables
Table 1
ID | Submission date | # submissions |
1 | 01/01/2022 | 5 |
1 | 01/02/2022 | 7 |
1 | 01/03/2022 | 3 |
Table 2
ID | Date Rate changed |
1 | 01/02/2022 |
I want to see the amount of submissions per Rate changed date till today()
ID | Date Rate changed | # submissions |
1 | 01/02/2022 | 10 |
I am trying to do with Sumarized columns etc, but somewhere my formula is not working