Forum Discussion
Calendar Table for Forecasting between Start & End Dates
I'm having difficulties with a table I am trying to create. I need to show FTE by Date for each Project Name, Location and Grade. The data I have shows FTE broken down into each location and gra...
Remove the 0 from the else part of the if statement, so that it will return blank instead
FTE Allocation = VAR CurrentDate = SELECTEDVALUE ( Calendar[Date] ) RETURN CALCULATE ( SUMX ( 'RM', IF ( 'Table'[Start Date] <= CurrentDate && 'Table'[End Date] >= CurrentDate, 'Table'[FTE] ) ) )By returning blank instead of 0 those values should be excluded from the visual.
johnt75
Super User
Super UserRemove the 0 from the else part of the if statement, so that it will return blank instead
FTE Allocation =
VAR CurrentDate =
SELECTEDVALUE ( Calendar[Date] )
RETURN
CALCULATE (
SUMX (
'RM',
IF (
'Table'[Start Date] <= CurrentDate
&& 'Table'[End Date] >= CurrentDate,
'Table'[FTE]
)
)
)
By returning blank instead of 0 those values should be excluded from the visual.
Oh my word! Google, AI, you name it, I was looking it up. So simple!
Thank you so much!