Forum Discussion
Uniform salary calculation
Hi all,
I have a salary table with employee salary for each month. I also have a table that pulls in timesheet info for each employee on a daily basis.
I am trying to summarize by employee, by each project and arrive at work logged and salary info for each month. I tried the Matrix visual, but I am getting this:
Instead it should be like below:
Here is the link to the pbix file:
Thanks!
Hi,
You may download my PBI file from here. Extend your Month Table to March to get that month's data in the matrix.
Hope this helps.
You are welcome. Done - see this file.
Ashish_Mathur neat! The sorting is by MonthIndex. Thank you again.
Yes. You are welcome.
5 Replies
- Ashish_MathurSuper User
Hi,
You may download my PBI file from here. Extend your Month Table to March to get that month's data in the matrix.
Hope this helps.
- ek2112Advocate II
Ashish_Mathur thank you! Is there a way to have January first and then Feb? I tried to sort by Month, but it is not visible.
- Ashish_MathurSuper User
You are welcome. Done - see this file.