Forum Discussion

RTW93's avatar
RTW93
Frequent Visitor
8 years ago
Solved

Count per day

Hey guys,   i try to solve my problem since 2 days... I have a table "login" with 2 Colums: [id] and [date] I Created a Extra Table "calendar" with all dates from the 01.01.2017 to the 30.07.201...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi RTW93,

     

    as a best practice you should use a measure and then apply it based on context because columns only add to your model, and if one expression can change into a measure do it instead of a column, but the syntax for the new colum in calendar table sould be one of this two:

     

    Count per day = CALCULATE(COUNT(Login[ID]), RELATEDTABLE(Login))
Count per day = COUNTROWS(RELATEDTABLE(Login))

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi RTW93,

 

You don't need to create a new column if you add the date column (from calendar table) and the ID and select summarize count it will give you the expected result be aware that you need to have both tables related.

 

 

Regards,

MFelix

 

 

RTW93's avatar
RTW93
Frequent Visitor
8 years ago

Hey MFelix,

 

thanks for your answer,  but i need the Colum saved in the table (using table/new Colum). Based on it i need to calculate some other things...