Counting (and graphing) dates over time

[aw3w2]

I am trying to count activation dates over time. The totals are correct, but I cannot get it to show activations per month.

I created a measurement- Site Activations, which works, however I cannot graph it over time. I think it is because there is not a time in the Activations table. I tried doing userelationship, but i cannot get it to work! Help!

Site Activations = CALCULATE(COUNT('Activation Report'[Date First Activated]),

                                    USERELATIONSHIP('Activation Report'[Date First Activated],'Calendar Table'[Date]))

Site Activations Measure is from Activations Table and Month/Year are from Calendar Table.

[danextian · Accepted solution]

Hi @aw3w2 

If  you're seeing a blank period that is most likely because your calendar table does not cover the dates in your fact table or you have a data type mismatch (datetime vs date). The column format in the designer does not matter but ensure you're using the same data types. You should be able to successfully do that in the query editor.

[Ashish_Mathur]

Hi,

What do you mean by " there is not a time in the Activations table."?  In Power Query, ensure that that data type of the Date first activated column is Date.  Also, if there is already a Many to One relationship from the Date first activated column to the Date column of the Calendar table, then this simple measure should work

Measure = COUNT('Activation Report'[Date First Activated])

If it does not help, then share the download link of the PBI file.