Forum Discussion

paulorojog's avatar
paulorojog
Regular Visitor
4 years ago
Solved

Get last value from another table

Hi!   I'm struggling to get a matrix on my dashboard that shows the last project that an employee has been assigned.   For this I have two tables. The first one is Employee, that has IDEmployee, ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, paulorojog ;

    You could modify it .

    Last client = 
var _table=SUMMARIZE(FILTER('NSR',EOMONTH([Periodo],0)=EOMONTH(TODAY(),0)),[Numero Profesional])
return IF(NOT( MAX('Dotación'[Nº pers.])) in _table ,BLANK(),
         CALCULATE(max(NSR[Cliente]),LASTNONBLANK('Calendar'[Date],CALCULATE(max(NSR[Cliente])))))
    Last project = 
var _table=SUMMARIZE(FILTER('NSR',EOMONTH([Periodo],0)=EOMONTH(TODAY(),0)),[Numero Profesional])
return IF(NOT( MAX('Dotación'[Nº pers.])) in _table ,BLANK(), 
          CALCULATE(max(NSR[Texto]),LASTNONBLANK('Calendar'[Date],CALCULATE(max(NSR[Texto])))))

    The final output is shown below:


    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

paulorojog's avatar
paulorojog
Regular Visitor
4 years ago

Thank you! Your solution is the expected behavior. The only thing is still missing is how I could get with this that if an employee does not have a project assigned in the current month, the columns should be in blank.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

You are welcome.  Drag Month from the Calendar Table into a slicer and select a certain month.  Do you not get the expected result?