Forum Discussion

bwasham's avatar
bwasham
Frequent Visitor
8 years ago
Solved

Calculated Column with Var and IF Then Else

I am trying to create a matrix in Power BI with a column for Full Time Equivalents (FTE).  The Table looks like this (Please note this is an example the actual table has well over a million lines for...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    I would approach this as 3 measures:

     

    August = 186 

FTE1Measure = 
VAR __FTE = DIVIDE(SUM(Table8[Hours]),[August])
RETURN IF(__FTE>1,1,__FTE)

FTEMeasure = 
IF(HASONEVALUE('Table8'[Staff]),[FTE1Measure],SUMX(SUMMARIZE('Table8',[Staff],"__FTE",[FTE1Measure]),[__FTE]))

    FTEMeasure is the one that you want to use, the other two are just intermediate.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Does your data really look like what you posted or do you have multiple hour entries per person?

RODRIGO_teixeir's avatar
RODRIGO_teixeir
Frequent Visitor
6 years ago
@Greg_Deckler, good afternoon!

I am following your solutions, but I have the following problem to calculate the total, at the row level is calculating correct, I wanted to calculate the total of the column calculated in the visual, but I can't. Follow a brief explanation of what I'm looking for, I have a base customer, I'm looking for the customer's last purchase date, to find out if it has more than 60 days, with this condition I wanted to calculate your next sell for 30 days from the date he was considered reactivated, until now after a lot of struggle, I managed, but I'm still looking for the total.
.