Forum Discussion

koorosh's avatar
koorosh
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

how 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 per month".

Thanks . 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 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

5 Replies