Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Dear Power BI Community,
Our company general ledger has payroll data that has charged to various projects based on employee ID. I am trying to find a DAX formula that will me to calculate the % of payroll time by Employee ID based on project filter criteria. I am having a hard time figuring out how to do this.
Any suggestions?
Thank you,
Brian
@bslusarz
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you. Here is the Pivot Table in simplified format which summarizes our general ledger payroll data by project and employee. The amounts are dollar amounts but for confidentiality, we would like to have the data presented as a % of employee's total payroll for a given month. I'm pasting the Pivot Table and GL, not the actual PowerPivot Data but would appreciate guidance on any measures that could make this work. Thank you!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
30 | |
15 | |
11 | |
10 | |
9 |