Forum Discussion
Solved
Power BI measure - avoid table with ID on every date between startdate and enddate >10.000.000 rows
I have a isue. I have 3 tables 1 -->calender table with date, and yearmont 1 -->employment, ID, startdate, enddate, organisationID, Group, employmentdate 1 --> organisation, OrganisationID, name ...
You should be able to do this with measures.
I have attached a pbix file with some sample data and measures that allow a result that looks like the following. Hopefully the concepts will apply to your situation.thank you very much. it did help
thank you very much. it did help