Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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. 😍
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
15 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
22 | |
11 | |
10 | |
10 | |
8 |