Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
17 | |
17 | |
16 |
User | Count |
---|---|
28 | |
27 | |
18 | |
14 | |
14 |