Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
girish_hm
Frequent Visitor

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

Hello,

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

girish_hm_1-1679690672191.png

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.

1 ACCEPTED SOLUTION

your expected outcome is incorrect for the first line.

 

lbendlin_0-1680016274544.png

 

View solution in original post

5 REPLIES 5
lbendlin
Super User
Super User

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

Hello,

 

Sorry for the incomplete information,

The outcome of the table A should be as below:

girish_hm_0-1679922283467.png

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

 

Hello Friends,

 

Any help on above request please.

 

Best Regards,

Girish

your expected outcome is incorrect for the first line.

 

lbendlin_0-1680016274544.png

 

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.