Newbie PQ question

[Rovex]

Hi, Apologies in advance if this is a bit on the basic side as I'm still trying to figure PQ out!!

I've been given a table of data with FTE amounts for a load of people per month. I have unpivoted it to get it into the format shown below

I need to build a chart showing the totals starting per month

I've tried putting in a measure using RankX and Filter and Earlier which I found online but couldn't get it to work. Any ideas Excel gurus??

Regards,

Tony

 

[Misca]

Try the following DAX measure:

FTE Starting:=VAR CurrentDate = MIN('Calendar'[Date])
VAR CurrentStaff = VALUES(Data[PID])
VAR PrevStaff = CALCULATETABLE(
    VALUES(Data[PID]),
    ALL('Calendar'[Date]),
    'Calendar'[Date]<CurrentDate
    )
VAR NewStaff = EXCEPT(
    CurrentStaff,
    PrevStaff
    )

RETURN
    COUNTROWS(NewStaff)

Adjust the table names to match the tables in your data model.

 

[JGordon11]

in PQ group by the month column and sum the FTE column