Forum Discussion

RodBaylon's avatar
RodBaylon
Frequent Visitor
7 years ago
Solved

Moving values to new dates

Hi there, 1st time posting a question so I apologize in advance for any eventual mistake. Trying to build a model to guess when job would be quoted based on a table which contains data for job names ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    7 years ago

    RodBaylon 

     

    I think you need to have a datetime dimension table. If you don't have, you need to create one first.

    You can set up the date scope of that table.

     

    Then you build relationship with your fact table. I think in the real data the relationship here should be one to many

     

    At last, you can use DAX to get the date 45 days ago.

     

     

    Hope this is helpful.

     

    Thanks and BR

    Ryan

ryan_mayu's avatar
ryan_mayu
Super User
7 years ago

RodBaylon 

 

I think you need to have a datetime dimension table. If you don't have, you need to create one first.

You can set up the date scope of that table.

 

Then you build relationship with your fact table. I think in the real data the relationship here should be one to many

 

At last, you can use DAX to get the date 45 days ago.

 

 

Hope this is helpful.

 

Thanks and BR

Ryan

  • RodBaylon's avatar
    RodBaylon
    Frequent Visitor
    7 years ago

    Thanks ryan_mayu for your simple solution and detailed explanation. t by creating a new column in my Data Model. Where I was not going anywhere was because I was trying to get this done by just one DAX formula and only virtual tables. Maybe I need to use things like CALCULATETABLE and VARIABLES to get it done.
    nonetheless, appreciate your input and have already implemented it to my model. Again, thanks a lot