Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I need a matrix to calculate the number of working days per person & per month. I've used the method in this video,https://www.youtube.com/watch?v=R8tDKwimSsY.
But the result is not what I'm looking for, it doesn't display all people. Below is the original data and matrix.
I guess the problem should be I have many rows for one person, and sample only has one row for each ID. I tried again after I remove all rows except the first row, the result is what I want.
Below is the DAX function I copied from sample. Please advise how to modify it.
Thank you very much.
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi Allison,
Now I understand what the problem is. I tried to add a SUMX(), but it doesn't work.
Can you please try with following data? I want to see how you will write the formula. Thank you.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thank you very much.
@hongyuliu
Can you share some sample data which I can copy-paste in Excel or your PBIX file along with desired results? Also, on what fields have you connected the calendar table to the data1 table?
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Fowmy,
Got some problem to insert table, sorry. Please kindly enter the data in your excel and try. I didn't connect any column between Calendar and Data1. If you want, it's fine. Thank you very much.
Data:
Result:
Hi,
You may download my PBI file from here.
Hope this helps.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
107 | |
98 | |
39 | |
34 |
User | Count |
---|---|
149 | |
121 | |
76 | |
74 | |
51 |