how many values per months

[koorosh]

Hello All,

There is a table with the following columns:

users, courses, course date, login date

Need a table to show users with their "number of courses per month" and "number of login per month".

Thanks . 

[Anonymous · Accepted solution]

HI @koorosh,

I think you need to use a date table that is not linked to current table records. Then you can use the current user's fields on row fields, data table field with year and month hierarchy on column fields.
After these steps, you can write two measure formulas to calculate the different calculations based on the current category group and use them on value fields.

number of courses per month =
CALCULATE (
    COUNTA ( Table[courses] ),
    FILTER ( ALLSELECTED ( Table ), [course Date] IN VALUES ( Date[Date] ) ),
    VALUES ( Table[Users] )
)

number of login per month =
CALCULATE (
    COUNT ( Table[login Date] ),
    FILTER ( ALLSELECTED ( Table ), [login Date] IN VALUES ( Date[Date] ) ),
    VALUES ( Table[Users] )
)

Regards,

Xiaoxin Sheng

[vojtechsima]

Hi, @koorosh ,
Something like this?
Creating matrix, putting months as columns, User as rows, count of login and course date as Values:

[koorosh]

Hello and Thanks,

The months for login dates have not been shown in the matrix.

[koorosh]

https://drive.google.com/file/d/1BMTyctput8hLuiOgbtzNgK4vMYq9VJtw/view?usp=sharing

https://docs.google.com/spreadsheets/d/1nfea29p1gkhwhzF7AHT4gF9_3WKNs4F7/edit?usp=sharing&ouid=11435...

[koorosh]