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.
your expected outcome is incorrect for the first line.
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).
Please show the expected outcome based on the sample data you provided.
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.
Any help on above request please.
You are Champ bro, working as expected. Thanks a ton. 😍
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.