User Profile
AceB_
Regular Visitor
Joined 2 years ago
User Widgets
Contributions
Re: How can I Count the Occurence of Quarters?
Sorry I can't share the file since it contains sensitive information. However I think I identified the problem. My table now looks like this: User Quarter Sum of occurence A Q3 13 B Q3 13 C Q3 13 D Q3 13 E Q4 15 F Q1 23 G Q3 26 So the problem is that it adds up the count for each quarter (for ex, Q3 for user G shows 26 which is 13+13), and then it adds 26 to 26 for other users etc... So it calculates it as a sum rather than a count838Views0likes0CommentsHow can I Count the Occurence of Quarters?
I have a table that contains the names of users, and the date of payment for each one of them. Users Date of payment A 12/12/2020 B 3/1/2021 C 9/8/2021 Power BI then automatically creates a hierarchy for the dates and thus shows me what the quarter is for each date. I would like to count the number of times the users have paid during each quarter. So for example, I would like to know how many users paid us during Q1. To do so, I need to count the number of times the quarters occur in the column, however, when I plug in this: " Occurrence = COUNTROWS ( FILTER( 'Table', 'Table'[Date of payment].[Quarter] = EARLIER( 'Table'[Date of payment.[Quarter] ) ) )" The counts are completely wrong. Any idea how to fix this?Solved886Views0likes5Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.