Forum Discussion

aw3w2's avatar
aw3w2
Regular Visitor
5 months ago
Solved

Counting (and graphing) dates over time

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 canno...
Need Help
  • danextian's avatar
    danextian
    5 months ago

    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's avatar
Ashish_Mathur
Super User
5 months ago

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.