Forum Discussion
101
2 years agoRegular Visitor
Dax- Calculation Help
Hello World, I need to calculate the Average Dues. Here, I have a Column called Clubs (It has name of all the clubs). 2nd, I have a column called Profit Center which compromises of our...
lbendlin
2 years agoSuper User
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
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/1447523
- 1012 years agoRegular Visitor
Club Name Agreement Number Last Name First Name Membership Type Profit Center Payment Date Payment Amount Club Orchid 2045 Hernandez Rab BASE Dues 5/10/2023 5 Club Rose 4045 Fernandez Carlos BASE Late Fee 5/10/2023 10 Club Orchid 4971 Samuel John BASE Dues 5/24/2023 20 Club Lily 5522 Jimenez Eli BASE Processing Fee 5/31/2023 5 Club Rose 6522 Tran Elizabeth BASE Dues 5/31/2023 30 Club Orchid 9535 Hobson Lexi PEAKPR Annual Fee 5/16/2023 5 Club Lily 8535 Style Harry PEAKPR Dues 5/16/2023 10 Club Orchid 9806 Minor Eugie PEAKPR Dues 5/19/2023 5