Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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.
Solved! Go to Solution.
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:
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
You are Champ bro, working as expected. Thanks a ton. 😍
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 3 |