Forum Discussion

JB_AT's avatar
JB_AT
Icon for Helper III rankHelper III
2 years ago
Solved

Calculating correct FTE

Good morning I have a table with employee information. It shows a changes in employee data. I have a ValidFrom and ValidTo column, which indicates that something changed in their record.   It ca...
Need Help
  • JB_AT's avatar
    JB_AT
    2 years ago

    I adapted the [Test FTE] to show the last value and it works as expected

    Test FTE = CALCULATE ( 
        LASTNONBLANK ( 'Emp History'[FTE], 1 ))
JB_AT's avatar
JB_AT
Icon for Helper III rankHelper III
2 years ago

I adapted the [Test FTE] to show the last value and it works as expected

Test FTE = CALCULATE ( 
        LASTNONBLANK ( 'Emp History'[FTE], 1 ))