Forum Discussion

Unknowncharacte's avatar
Unknowncharacte
Icon for Helper III rankHelper III
2 years ago
Solved

Time Intelligence Question

Hi,    I need to create a measure to calculate # of cases that were opened for longer than 90 days and visualize it on a historical line chart. So, something like if time frame between date open an...
Need Help
Tutorial Requests
  • vojtechsima's avatar
    vojtechsima
    2 years ago

    Hello, Unknowncharacte ,

    try something like this:

    LongerThan90 = COUNTROWS(FILTER('Fact Table', ( IF( ISBLANK('Fact Table'[Date Closed]), TODAY(), 'Fact Table'[Date Closed])  - 'Fact Table'[Date Opened] ) > 90))

     

     

ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
2 years ago

Your question has nothing to do with Time Intelligence functions.

 

Use COALESCE() to replace blank Closed Date on the fly.

= COALESCE( MAX( 'Fact Table'[Date Closed] ), TODAY() ) - MAX( 'Fact Table'[Date Opened] ) >= 90
  • Unknowncharacte's avatar
    Unknowncharacte
    Icon for Helper III rankHelper III
    2 years ago

    Alright, what would you refer it as?