Forum Discussion
Solved
Null Value Boolean Correction for Software Analysis
I have the following tables linked together by application name: Application Name: Family: Verssion: App9 Fam1 9 App8 ...
You can try to create a calculated column as
Support Ended? = VAR last_app_ver_SE_date_is_not_null = MINX ( FILTER ( Table2, EARLIER ( RELATED ( Table1[Version] ) ) < RELATED ( Table1[Version] ) && RELATED ( Table1[Family] ) = EARLIER ( RELATED ( Table1[Family] ) ) && NOT ( ISBLANK ( Table2[Support End Date] ) ) && Table2[Support End Date] < TODAY () ), RELATED ( Table1[Version] ) ) RETURN SWITCH ( TRUE (), NOT ( ISBLANK ( Table2[Support End Date] ) ) && Table2[Support End Date] < TODAY () || NOT ( ISBLANK ( last_app_ver_SE_date_is_not_null ) ), TRUE (), FALSE () )
You can try to create a calculated column as
Support Ended? =
VAR last_app_ver_SE_date_is_not_null =
MINX (
FILTER (
Table2,
EARLIER ( RELATED ( Table1[Version] ) ) < RELATED ( Table1[Version] )
&& RELATED ( Table1[Family] ) = EARLIER ( RELATED ( Table1[Family] ) )
&& NOT ( ISBLANK ( Table2[Support End Date] ) )
&& Table2[Support End Date] < TODAY ()
),
RELATED ( Table1[Version] )
)
RETURN
SWITCH (
TRUE (),
NOT ( ISBLANK ( Table2[Support End Date] ) )
&& Table2[Support End Date] < TODAY ()
|| NOT ( ISBLANK ( last_app_ver_SE_date_is_not_null ) ), TRUE (),
FALSE ()
)
I cannot tell you how appreciative and amazed I am that you contructed that quickly.
Many thanks from me to you and this community.
Glad to help. :)