Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Calculation for the time/date

Good morning community,   Can anyone help me to make a calculation in PowerBI for this event in the red circle? any advice would be helpful.     Thank you   regards   Poko
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hello everyone thank you for responses it works someway but I Don't get the result marked in the red circle above.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

You can create a measure as below to get the count of cases which more than 5 years:

Case of which for more than 5 years = 
CALCULATE (
    DISTINCTCOUNT ( '4CecLeadingCase4'[CecCaseId] ),
    FILTER (
        'CecCaseDetail',
        DATEDIFF ( 'CecCaseDetail'[DefinitiveJudgmentDate], TODAY (), YEAR ) > 5
    ),
    'CecCaseDetail'[Case] = "Stand"
)

Best Regards