Forum Discussion

DBNN's avatar
DBNN
Frequent Visitor
5 years ago
Solved

Datesbetween for multiple conditions

Hi,   I have a set of conditions that occur at certain dates.   I am looking for an easy way to count the number of days between the occurences and then calculate the standard deviation of all these...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi DBNN 

    1. Place Table1[Condition] in a table visual

    2. Place this measure in the visual

    Measure = 
STDEVX.P(
    ADDCOLUMNS (
        DISTINCT ( Table1[Date] ),
        "@DaysBetween",
            VAR current_ = Table1[Date]
            VAR next_ = CALCULATE ( MIN ( Table1[Date] ), Table1[Date] > current_ )
            RETURN
                IF ( NOT ISBLANK ( next_ ), next_ - current_ )
    ),
    [@DaysBetween]
)

    See it all at work in the attached file.

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi DBNN 

1. Place Table1[Condition] in a table visual

2. Place this measure in the visual

Measure = 
STDEVX.P(
    ADDCOLUMNS (
        DISTINCT ( Table1[Date] ),
        "@DaysBetween",
            VAR current_ = Table1[Date]
            VAR next_ = CALCULATE ( MIN ( Table1[Date] ), Table1[Date] > current_ )
            RETURN
                IF ( NOT ISBLANK ( next_ ), next_ - current_ )
    ),
    [@DaysBetween]
)

See it all at work in the attached file.

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.