Forum Discussion

SteveW_Stats's avatar
SteveW_Stats
Frequent Visitor
2 years ago

Graphing aggregated weekly data

Hi all   I'm trying to create a graph of bugs on our system on a bugs/week basis. So the graph should show a list of every Monday on the x-axis and a count of bugs on the y-axis. I've created a ta...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi SteveW_Stats ,

Please have a try.

Create a Date Table: If you haven't already, create a Date table with a column for dates and ensure it contains all possible dates, not just Mondays. This table will help us to make sure that every week is represented in your report.


Create a calculated Column for Mondays:

IsMonday = IF(WEEKDAY([DateColumn], 2) = 1, TRUE, FALSE)

Replace with the actual column name containing the dates in your Date table.[DateColumn]

 

Create Relationships: Build a relationship between your Date table and your Bugs table using the date columns.

 

BugCount = CALCULATE(COUNT('YourTable'[BugID]), 'DateTable'[IsMonday] = TRUE)

This measure will count the number of bugs for the dates marked as Mondays.

 

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.