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
Community ChampionHere 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.