Forum Discussion
How to keep measure's value same over time
I'm working data which have two fact_tables called fact_stat and fact_dyn. Fact_stat has only one dimensional date (report_date) and fact_dyn has two dimensional dates (report_date & forecast_date). ...
parry2k , Example data is quite simple:
Fact_dyn:
| Report_Date | Forecast_Date | Amount | Portfolio |
| 30.4.2020 | 30.4.2020 | 100 | A |
| 30.4.2020 | 30.4.2020 | 150 | B |
| 30.4.2020 | 30.4.2020 | 200 | C |
| 30.4.2020 | 1.5.2020 | 150 | A |
| 30.4.2020 | 1.5.2020 | 200 | B |
| 30.4.2020 | 1.5.2020 | 250 | C |
| 30.4.2020 | 2.5.2020 | 200 | A |
| 30.4.2020 | 2.5.2020 | 250 | B |
| 30.4.2020 | 2.5.2020 | 300 | C |
Fact_stat:
| Report_Date | Amount | Portfolio |
| 30.4.2020 | 400 | D |
| 15.5.2020 | 200 | D |
Dataflow: