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.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
106 | |
86 | |
77 | |
69 |
User | Count |
---|---|
120 | |
112 | |
94 | |
84 | |
75 |