Forum Discussion

Oopa's avatar
Oopa
Frequent Visitor
6 years ago

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). ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Oopa share raw data, you need to have date dimension in your model to make it all work.

Oopa's avatar
Oopa
Frequent Visitor
6 years ago

parry2k , Can I somehow attach powerbi file here?

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    Oopa share using one drive / google drive.

    • Oopa's avatar
      Oopa
      Frequent Visitor
      6 years ago

      parry2k , Example data is quite simple:

       

      Fact_dyn:

      Report_DateForecast_DateAmountPortfolio
      30.4.202030.4.2020100A
      30.4.202030.4.2020150B
      30.4.202030.4.2020200C
      30.4.20201.5.2020150A
      30.4.20201.5.2020200B
      30.4.20201.5.2020250C
      30.4.20202.5.2020200A
      30.4.20202.5.2020250B
      30.4.20202.5.2020300C

       

      Fact_stat:

      Report_DateAmountPortfolio
      30.4.2020400D
      15.5.2020200D

      Dataflow: