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))

     

     

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

    Thank you so much for the reference!