How to get related Time Window from another table based on the created time

[girish_hm]

Hello,

I have two tables imported in power bi with the common field Environment as below.

I want the related Time Window to be taken in Table A from Table B for the related Environments.

Appreciate if get an help on this.

[lbendlin]

Use a calendar table. Use measures. Or consider using TREATAS.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[girish_hm]

Hello,

Sorry for the incomplete information,

The outcome of the table A should be as below:

Basically, a new column to be created to get the Time Window from Table B for each respective Environments basis the Created Time.  

Below is sample data in pbix file.
https://drive.google.com/file/d/1NL_MmPb8ZHMqAUHw88HrTtJ5oipUKcTG/view?usp=share_link

Best Regards,

Girish

[girish_hm]

Hello Friends,

Any help on above request please.

Best Regards,

Girish

[lbendlin · Accepted solution]

your expected outcome is incorrect for the first line.

[girish_hm]

You are Champ bro, working as expected.  Thanks a ton. 😍