Forum Discussion
Create new table with matrix visualization
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
Measure = CALCULATE(
SUM(NUM_SUB[# Sumbissions]),
FILTER(ALL(Marketingratechange),Marketingratechange[Changed_Date]<= MAX(Marketingratechange[Changed_Date]))
)
No RepliesBe the first to reply