topic Re: How to get related Time Window from another table based on the created time in DAX Commands and Tips

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

girish_hm — Fri, 24 Mar 2023 20:47:58 GMT

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 — Mon, 27 Mar 2023 01:05:02 GMT

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

girish_hm — Mon, 27 Mar 2023 13:17:02 GMT

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 — Tue, 28 Mar 2023 14:16:32 GMT

Hello Friends,

Any help on above request please.

Best Regards,

Girish

lbendlin — Tue, 28 Mar 2023 15:11:41 GMT

your expected outcome is incorrect for the first line.

girish_hm — Tue, 28 Mar 2023 16:03:30 GMT

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