Line chart with 3 lines - daily, weekly, monthly

Hi Jared_d,

You could try below measure, create month and week column in table like below

month = MONTH('active user'[Date])
week = WEEKNUM('active user'[Date]) 

then create measures like below

monthly = CALCULATE(SUM('active user'[amount]), FILTER(ALL('active user'), 'active user'[month]=MIN('active user'[month])))
monthly kpi = CALCULATE(SUM('active user'[amount]), FILTER(ALL('active user'), 'active user'[month]=MIN('active user'[month])-1))
weekly  = CALCULATE(SUM('active user'[amount]), FILTER(ALL('active user'), 'active user'[week]=MIN('active user'[week]))) 
weekly kpi = CALCULATE(SUM('active user'[amount]), FILTER(ALL('active user'), 'active user'[week]=MIN('active user'[week])-1)) 
daily kpi = CALCULATE(SUM('active user'[amount]), FILTER(ALL('active user'), 'active user'[Date]=MIN('active user'[Date])-1))

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for your awesome reply. However I should've made it more clear.

The B column on my screenshot from excel contains users ids not amount of users. It means that I have to do something to create amount column for each day.

It looks like that with real data:

What I'd like to do is to create new calculated table with Data(daily), AmountOfUsersId and AmountOfAndroids, AmountOfiOS.

EDIT: I've found out that with your post I'll be able to do what I want so I can go further into it from now on. BIg thanks for your time :)