Forum Discussion

PBI_37's avatar
PBI_37
Helper I
3 years ago
Solved

Question about data modeling

Hi everyone,   I have a question about my model. I have 2 fact tables (actual and forecast) and 2 dimension tables (Products and Calendar). I want to calculate the difference between the actual a...
Need Help
  • vojtechsima's avatar
    vojtechsima
    3 years ago

    Hello, PBI_37 ,
    Yes, you're right. You can append both fact tables, keep only BatchNum column, remove duplicity and make that as third dimension and connect it back to the fact tables as normal dimension.

  • PBI_37's avatar
    PBI_37
    3 years ago

    Thank you vojtechsima

PBI_37's avatar
PBI_37
Helper I
3 years ago

Thank you vojtechsima