Count Number of jobs in previous quarter & -2 quar...

Rob_Morris · ‎07-21-2023

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.

foodd · ‎07-21-2023

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

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

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

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

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