Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
Tips and Tricks
  • mwegener's avatar
    mwegener
    6 years ago

    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.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

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.