Forum Discussion
Helper IVrelationships between 2 tables
Hi I have two tables that i cam trying to create a relationship with. each time i set it up with a new column that i have created in both tables i can see some data but not the complete list.
i have creaded a column in both tables called Key1 that has the following creteria.
6 Replies
- Greg_Deckler
Community Champion
FCF - Hard to say, what are you seeing? Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
FCFhi this is the sample data of what is in the tables
table 1 havatec
when i select the activity Havatec the column Havetec-Stem/hr should display a value, and it does
the problem is that all activities are displaying the havatec value, and they should be at 0
v-deddai1-msftCommunity Support
Hi FCF ,
What's in your Havetec-Stem/hr ? Would you please show us more details by sample pbix file? It is quitely difficult to figure it out with your description.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Dedmon Dai
- amitchandak
Super User
FCF , to me date itself is a key, unless it not aproper date. Also in case, they are transactional table, you should join both with a date table.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
Appreciate your Kudos.
