Forum Discussion

ek2112's avatar
ek2112
Advocate II
7 years ago
Solved

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:

 

 

 

Pbix file

 

Thanks!

 

 

 

 

 

 

 

 

5 Replies

  • 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's avatar
      ek2112
      Advocate 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.