Forum Discussion

Berrcikk's avatar
Berrcikk
Frequent Visitor
3 years ago
Solved

Calculation to filter Data

Hi all,   Currently I'm working on to add additional filters/columns, to provide information how a certain case should be treated. What I need to do, is to classify a certain case, if it should be...
Need Help
Tips and Tricks
  • DataInsights's avatar
    DataInsights
    3 years ago

    Berrcikk,

     

    Try these calculated columns:

     

    IS Case Active = 
VAR vCase = Table1[CASE]
VAR vToday =
    TODAY ()
VAR vTable =
    FILTER ( Table1, Table1[CASE] = vCase && Table1[DAY] = vToday )
VAR vResult =
    IF ( ISEMPTY ( vTable ), 0, 1 )
RETURN
    vResult
    IS Case Closed = IF ( Table1[IS Case Active] = 1, 0, 1 )

     

     

DataInsights's avatar
DataInsights
Super User
3 years ago

Berrcikk,

 

Try these calculated columns:

 

IS Case Active = 
VAR vCase = Table1[CASE]
VAR vToday =
    TODAY ()
VAR vTable =
    FILTER ( Table1, Table1[CASE] = vCase && Table1[DAY] = vToday )
VAR vResult =
    IF ( ISEMPTY ( vTable ), 0, 1 )
RETURN
    vResult
IS Case Closed = IF ( Table1[IS Case Active] = 1, 0, 1 )

 

 

  • Berrcikk's avatar
    Berrcikk
    Frequent Visitor
    3 years ago

    Thanks! Works out perfectly