Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculate total on last return date

Hi   I'm trying to calculate the number of employees per customer.  I am struggling with calculating the number of employees as the companies submitted a return sometimes quarterly or even annually...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

HI Anonymous

 

Try this MEASURE

 

Measure =
CALCULATE ( SUM ( Table1[No of employees] ), LASTDATE ( Table1[Return Date] ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you Zubair_Muhammad - this works perfectly.

     

    Kind regards

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hello

       

      Just building on my previous question

       

      how would I calculate the total on the return data previous to the last date?

       

      Thanks

       

      Jo.