Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Monthly output without reference date

I want to create a matrix visual or line chart where I can show the development of the FTE (or something else) on a monthly base. Problem is that my dataset doesn't have a reference date column, but ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Sorry, I forgot to consider the null in the ValidUntil column.

     

    please check the below amended measure.

     

    SUM FTE =

    CALCULATE (
    CALCULATE(SUM( Data[FTE]), FILTER(Data, Data[Validuntil] <> BLANK())),
    FILTER(Data, Data[Validfrom] <= MAX ( dates[Date] ) && Data[Validuntil] >= MIN(dates[Date])
    )) + CALCULATE( CALCULATE(SUM( Data[FTE]), FILTER(Data, Data[Validuntil] = BLANK())),
    FILTER(Data, Data[Validfrom] <= MAX ( dates[Date] )
    ))
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Sorry, I forgot to consider the null in the ValidUntil column.

 

please check the below amended measure.

 

SUM FTE =

CALCULATE (
CALCULATE(SUM( Data[FTE]), FILTER(Data, Data[Validuntil] <> BLANK())),
FILTER(Data, Data[Validfrom] <= MAX ( dates[Date] ) && Data[Validuntil] >= MIN(dates[Date])
)) + CALCULATE( CALCULATE(SUM( Data[FTE]), FILTER(Data, Data[Validuntil] = BLANK())),
FILTER(Data, Data[Validfrom] <= MAX ( dates[Date] )
))