Forum Discussion
USERELATIONSHIP with multiple dates
I have a list of services with IDs that have an open date and a closed date on the same record line in a table. They look like so: ID Opened Date Closed Date 1 10/22/2019 11/4/2019 ...
Hi Anonymous,
you need to count the Facttable "Services" and not on a Dimensiontable "ID".
You may download my PBIX file from here.
Hope this helps.Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi,
Ensure that there is an inactive relationship between the Closed Date column of your Data Table to the Date column of your Calendar Table.