Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper I
Helper I

Count Number of jobs in previous quarter & -2 quarters

I have a table which lists job numbers and job date fields
I would like to create a measure that counts the total number of jobs in the previous financial quarter based on the current date  eg 21st July - so previous quarter to use for summing up would be 1st April 2023 - 30th June 2023.

I would also like another measure that counts two quarters back to enable comparison - eg 1st Jan 2023 - 31st March 2023.

The only help I can find online is in relation to summing up total sales values and when i have swapped the SUM for COUNTROWS this doesn't seem to work.


Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).

Please show the expected outcome based on the sample data you provided.


This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.