Forum Discussion
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 ...
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
Super User
Super User
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