Graph Quantity of Incident Reports by Month Using Date Log

[AThomasCF]

Hello everyone

My company using a third party data entry software that generates reports and timestamps them. They are then exported by form type, such as "Audit", or "Changeover, or "Non-Conformance"

My goal is use Power BI to take the entries in the date log, count how many happen per month (or week), and then bar graph the findings.

For example:

FormDate

1/11/2023 9:27

1/11/2023 9:27

1/11/2023 9:27

1/11/2023 9:27

1/13/2023 5:13

1/13/2023 5:13

2/16/2023 5:13

3/14/2023 5:13

And make it look something like this:

I have been able to use the Count/Earlier in calculated colums to get the number of incidents I need, but I cannot seem to get that to work in a graph.

[AThomasCF · Accepted solution]

UPDATE: Solved on my own. Wrote a Countrows measure and applied date heirachy to the timestamps