Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
nick9one1
Helper II
Helper II

show growth over time

I have a log table that contains an action, user id and date/time. 

nick9one1_0-1720538415710.png

 

I would like to produce a line chart that shows continual user growth over time. 

the Title column would need to only show the first login for each user. So that would be the first instance of 'launched app'.

How can I achieve this? Thank you 


1 ACCEPTED SOLUTION
nick9one1
Helper II
Helper II

I think I've figured this out. 

 

I created a column that has a 1 for the first appearance of each user email;

First Login = 
VAR _class =
    CALCULATE(
        MIN('Log'[Date]),
        ALLEXCEPT('Log', 'Log'[email])
    )
RETURN
    IF('Log'[Date] = _class, 1, BLANK())

 

nick9one1_1-1720712147040.png

 

 

 Next I created a measure to count the logins cumulatively (dark blue line)

running sum = CALCULATE( 
 SUM('Log'[First Login]), 
 FILTER(ALLSELECTED('Log'), 
 'Log'[Date] >= DATE(YEAR(MAX('Log'[Date])),1,1) &&
 'Log'[Date] <= MAX('Log'[date])
 ))

 

nick9one1_2-1720712364258.png

 

 

 

 

 

View solution in original post

2 REPLIES 2
nick9one1
Helper II
Helper II

I think I've figured this out. 

 

I created a column that has a 1 for the first appearance of each user email;

First Login = 
VAR _class =
    CALCULATE(
        MIN('Log'[Date]),
        ALLEXCEPT('Log', 'Log'[email])
    )
RETURN
    IF('Log'[Date] = _class, 1, BLANK())

 

nick9one1_1-1720712147040.png

 

 

 Next I created a measure to count the logins cumulatively (dark blue line)

running sum = CALCULATE( 
 SUM('Log'[First Login]), 
 FILTER(ALLSELECTED('Log'), 
 'Log'[Date] >= DATE(YEAR(MAX('Log'[Date])),1,1) &&
 'Log'[Date] <= MAX('Log'[date])
 ))

 

nick9one1_2-1720712364258.png

 

 

 

 

 

mickey64
Super User
Super User

How about use a measure below?

    UserNum = DISTINCTCOUNT(Log Table[UserID])

    X-axis:Date

    Y-axis:UserNum

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.