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

Omega's avatar
Omega
Impactful Individual
7 years ago

Welcome to Power BI Community. 

 

Please share sample data and screenshots of the expected results :)

  • RodBaylon's avatar
    RodBaylon
    Frequent Visitor
    7 years ago

    OmegaHi, I'm still trying to figure out on how to attach files to this chat.

     

    Inserted a pic of what I am trying to do in POWER BI.

    Column A is a date from the system and Column B is a calculated one (Column A - 45). And I'd to link values from column C to column B.

    I understand I could have it done at query level however I would like to know if a measure with DAX could do the trick dynamically.