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 dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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. 😍
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |