Forum Discussion

RaulPBI's avatar
RaulPBI
Icon for Helper II rankHelper II
9 years ago
Solved

PROBLEMS WITH TIME INTELLIGENCE

Hello everybody.   I have a problem with a model. It contains only three tables, one of them is date, and the rest are fact tables, costs by date and shipments by date. The thing is that I am not a...
Need Help
  • RaulPBI's avatar
    RaulPBI
    9 years ago

    Hi,

     

    I have solved it by this way:

     

    I have created another column in fact table which is date too, like this:

     

    Calculated date = albaran_salida_fechas[create_date].[Date]

     

    then I changed the relationship between these two tables, so "date" in calendario table is connected by"calculated date" with fact table. That´s perfect for me.

     

    Thanks for your time