Uniform salary calculation

[ek2112]

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:

Pbix file

Thanks!

[Ashish_Mathur · Accepted solution]

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.

[Ashish_Mathur · Accepted solution]

You are welcome.  Done - see this file.

[ek2112 · Accepted solution]

@Ashish_Mathur neat! The sorting is by MonthIndex. Thank you again.

[Ashish_Mathur · Accepted solution]

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.

[ek2112]

@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_Mathur · Accepted solution]

You are welcome.  Done - see this file.

[ek2112 · Accepted solution]

@Ashish_Mathur neat! The sorting is by MonthIndex. Thank you again.

[Ashish_Mathur · Accepted solution]

Yes.  You are welcome.