Forum Discussion

pbi_rafal's avatar
pbi_rafal
Frequent Visitor
3 years ago
Solved

Connection between different dates

Hi,

 

I have two data sets, where the main one is refreshed every day and the 2nd one is based on the user's ad hoc intervention. To connect two data sets together I've created Reporting_Date table with distinct reporting_dates. Now I would like to create Manual_Date column where I assigned for each reporting date relavant manual input date. Can you help me with the DAX formula to receive Manual_Date column? Manual Input date should be equal or higher than Reporting_Date but also we should take into account that we need to take the most recent one (if exist)

 

Thanks

General Comment
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    3 years ago

    Hi pbi_rafal ,

     

    From what I can understand the first two table are is your initial input try the following steps:

    Power query:

    1. Do a new table with a merge of both table by date
    2. Expand the column Manual Input
    3. Fill down

    1.

     

     

    2.

     

    3.

     

     

     

     

     

     

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    Hi pbi_rafal ,

     

    From what I can understand the first two table are is your initial input try the following steps:

    Power query:

    1. Do a new table with a merge of both table by date
    2. Expand the column Manual Input
    3. Fill down

    1.

     

     

    2.

     

    3.