Forum Discussion
koorosh
Post Partisan
4 years agohow many values per months
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 pe...
- Anonymous4 years ago
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
Super User
4 years agoHi, koorosh ,
Something like this?
Creating matrix, putting months as columns, User as rows, count of login and course date as Values:
- koorosh4 years ago
Post Partisan
Hello and Thanks,
The months for login dates have not been shown in the matrix.