Closed jesusitd closed 3 years ago
Working for AWKO:
Talc Usage Total Applications = 'Cases'[talc_usage_years] * 'Cases'[Talc Usage Months Per Year] * 'Cases'[Talc Usage Applications Days per Month] * COALESCE( 'Cases'[Talc Usage Duration Frequency Times a Day], 1 )
(Applied to APPLICATIONS calculated columns)
ALSO: TALCUM USAGE QUALIFYING YEARS AND APPLICATIONS CANNOT CONSIDER 1982 FOR NOW.
Must use regular hierarchy or precedence: Start Year -> Tubal Ligation ? -> DX ? -> Discontinued Date.
Talc Usage Years Qualifying = -- COALESCE( 'Cases'[Talc Usage 1982 Before Tubal Ligation], 'Cases'[Talc Usage 1982 Before Discontinued Date] )
COALESCE( 'Cases'[Talc Usage Before Tubal Ligation], 'Cases'[talc_usage_years] )
Talc Usage Before Tubal Ligation = VAR _diff = DATEDIFF( 'Cases'[Talc Usage Start Date], 'Cases'[Talc Tubal Ligation Date], YEAR ) RETURN IF( _diff >= 0, _diff, BLANK() )
Talc P7 Usage Frequency = IF( 'Cases'[Talc Usage Years Qualifying] >= 6 || COALESCE( 'Cases'[Talc Usage Applications Before Tubal Ligation], 'Cases'[Talc Usage Total Applications] ) >= 2000, "Meets Criteria", "Does Not Meet Criteria" )
/* IF( 'Cases'[Talc Usage Years Qualifying] >= 6 || COALESCE( 'Cases'[Talc Usage 1982 Applications Before Tubal Ligation], 'Cases'[Talc Usage 1982 Applications Before Discontinued Date] ) >= 2000, "Meets Criteria", "Does Not Meet Criteria" ) */
Also released:
Waiting HK revision
All Talc usage being calculated well.
this has the constants used for the application