Forum Discussion

Kerry_M's avatar
Kerry_M
Icon for Helper II rankHelper II
1 year ago
Solved

Dax measure to count client STARTS when I client has multiple records

I have a table that contains: Client, Start Date, Stop Date for a subscription. Clients can have multiple subscriptions at the same time (starting and ending on different dates).  Clients can also st...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    Based on the table that you have shared, show the expact result which you are expecting.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Does it have to be DAX?  This seems like immutable data, so could also be done in Power Query?

  • Kerry_M's avatar
    Kerry_M
    Icon for Helper II rankHelper II
    1 year ago

    Actually I would love to do it in Power Query if I can but I don't know how. The table has about 600,000 records so takes a long time when I try out ideas.