Turns All Open Cases to Close on Bar Chart

[Chanleakna123]

hi team , 

i use the status as manual on my file and i used Bar chart by counting the ID . 

My purpose is to visualize , if the Case >30 Days it will show all of the Open Case to Close , but if it's <30 Days , it Remains the Same , show "Close " and "Open" Options . 

how to success on this ? 

[v-cherch-msft]

Hi @Chanleakna123

It seems you need to use DATESBETWEEN Function. If it is not your case, please share more about your simplified data sample and expected output. 

Regards,
Cherie

[Chanleakna123]

Hi , 

below is what my expectation : 

My purpose is to visualize , if the Case >30 Days it will show all of the Open Case to Close , but if it's <30 Days , it Remains the Same , show "Close " and "Open" Options . 

how to success on this ? 

Therefore if the Case still open from Jan to Aug , it will automatically closed , 

because i dun wanna see case open from Jan to Aug , only in september , Due to it will less than 30 days. if it more than 30 days Close automatically.  

[v-cherch-msft · Accepted solution]

Hi @Chanleakna123

It seems you need to create a calculated column and drag it to 'Legend' for your chart. Show a simplified sample here.

ChangeState =
IF (
    DATEDIFF ( Table4[Date], TODAY (), DAY ) <= 30,
    Table4[State],
    IF (
        DATEDIFF ( Table4[Date], TODAY (), DAY ) > 30
            && Table4[State] = "Open",
        "Close",
        Table4[State]
    )
)

Regards,

Cherie

[Chanleakna123]

@v-cherch-msft you're awesome.