Forum Discussion

Schwurblini's avatar
Schwurblini
Frequent Visitor
3 years ago
Solved

Count Distinct Numbers from Start to Today

Hi All   I am trying to create a report that shows how many customers have been active up to the current day, filtered by Week Each and every week, i would need to add the newly joined customer wh...
Need Help
  • TomasAndersson's avatar
    TomasAndersson
    3 years ago

    Hi!
    Sounds like you want a cumulative (distinct) count? Is this table connected to a Date/Calendar table?
    If so it should be enough with

    Cumulative Customers = 
CALCULATE(
    DISTINCTCOUNT(Table[Customer]),
        FILTER(ALL(Dates),Dates[Date]<=max(Dates[Date])
    )
)

    You'd have to adjust table and columns names according you your data. If any of the columns in your table is a date column (such as [Week/Date]), that should work as well. 

Schwurblini's avatar
Schwurblini
Frequent Visitor
3 years ago

Wow thanks, im still new to the whole DAX buisness, thank you Tomas and bolfri for the fast and precise help