locked
Consecutive Date grouping RRS feed

  • Question

  • Consecutive Dates groups into one group:
    If there is  day in between then we get a new group.

    We need a DAX to generate the [Grouping] measure: 
    Afterwards I do a DistinctCount on the [Grouping] to get the Action "frequency" (using DAX)

    Data source is: 
    User Date Action
    A 1 1
    A 2 1
    A 3 0
    A 4 1
    A 5 1

    B 1 1
    B 2 0
    B 3 0
    B 4 1

    And this is expected result from above :
    User Grouping 

    A 2
    B 2

    many thanks

    Tuesday, December 19, 2017 12:39 PM

Answers

All replies