Complex IF or ISBLANK

Kyle_Wolfe_Ohio — Mon, 06 May 2024 12:47:37 GMT

I have a pretty complex script & I am stuck on the final WHERE component. The following image is straight from the table that captures the "Date Filled" and "Date Vacated" information I need to use for some reports on our organization's positions.

The first row indicates that the position was vacated and refilled = Filled

The second row indicates a brand new position that has never been filled or vacated = Vacant

The third and fourth rows indicate the position has only been occupied once and never vacated = Filled

I have compiled the following, but it is NOT showing the second row in the image above as vacant and I am not sure how to include it in the formula:

Is Vacant? =

VAR vToday =

TODAY ()

VAR vResult =

SWITCH (

TRUE,

NOT ISBLANK('Stale Pos PersNet PCR'[Date Vacated]), IF('Stale Pos PersNet PCR'[Date Vacated] >='Stale Pos PersNet PCR'[Date Filled], "Yes", "No"),

ISBLANK ('Stale Pos PersNet PCR'[Date Vacated]), "No", "Yes"

)

RETURN

vResult

Re: Complex IF or ISBLANK

Greg_Deckler — Mon, 06 May 2024 12:55:35 GMT

Kyle_Wolfe_Ohio Maybe:

Is Vacant? = VAR vToday = TODAY () VAR vResult = SWITCH ( TRUE, [Date Filled] = BLANK() && [Date Vacated] = BLANK(), "Yes", [Date Vacated] <> BLANK() && [Date Vacated] >= [Date Filled], "Yes", "No" ) RETURN vResult

Re: Complex IF or ISBLANK

Kyle_Wolfe_Ohio — Mon, 06 May 2024 13:12:57 GMT

That worked! Thanks

topic Re: Complex IF or ISBLANK in DAX Commands and Tips

Complex IF or ISBLANK

Re: Complex IF or ISBLANK

Re: Complex IF or ISBLANK