Forum Discussion
Making a reationship without making a huge table
Here is the data based on the date range concept. See this file.
What I did is this:
- In your 2nd table, I called Activity, I added a list of dates between Start and Finish dates, then expanded that.
- In the 1st table, called Table, I merged the Activity and Date to the Date Range
- Then I expanded the efficiency field.
- I made sure Activity was not set to load
- Made sure Table was set to load.
This is what is now in the data model.
If that isn't what you want, be very very clear in your follow up. THanks!
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
How do you want to merge the tables, Based on the start date, end date, or in between the dates? And if in between, what about duplicates? Or are you sure there can be none?
Here is the data based on the date range concept. See this file.
What I did is this:
- In your 2nd table, I called Activity, I added a list of dates between Start and Finish dates, then expanded that.
- In the 1st table, called Table, I merged the Activity and Date to the Date Range
- Then I expanded the efficiency field.
- I made sure Activity was not set to load
- Made sure Table was set to load.
This is what is now in the data model.
If that isn't what you want, be very very clear in your follow up. THanks!
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
That's exactly what I need. Between the dates, with the reference being the activity and the date from table 1.
I was unable to use Power BI because computer problems, but I'll try this solution now.
Thanks a lot.
