search

intakedesk / PowerBI-General

Placeholder for issues migrated from Jira
1 stars 0 forks source link

FIX Rosen Hernia Mesh Criteria, Scheduled 90 days or less card is not counting #611

Closed jesusitd closed 3 years ago

jesusitd commented 3 years ago

New DAX to fix:

HM Four P2.2 Scheduled 90 Days Exclusive =
IF(
    LEN( 'Cases'[Hernia Mesh Revision Surgery Years] ) = 0
        && 'Cases'[Hernia Mesh Scheduled Revision Date vs Case Sent Date] > 0
        && 'Cases'[Hernia Mesh Scheduled Revision Date vs Case Sent Date] <= 90,
    "Meets Criteria",
    BLANK()
)
jesusitd commented 3 years ago

DONE Rosen DONE Rosen Paralegal

jesusitd commented 3 years ago

Done. Thanks to Amanda for raising the alarm.