Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Difference between two dates in a measure

Hello everyone! I have the following measure: MaxDate = CALCULATE(MAX(Mastercalendar[Date]),filter(Mastercalendar,Mastercalendar[Weekday]<=5))   The objective is to give me the maximum date o...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    The error was I needed to clear some other filters from the mastercalendar.
    This works:

    CALCULATE(CALCULATE([occurrences],
    FILTER(Table,([MaxDate]-uvw_GBS_KPIs_HR_v2[opened_at])*1>15&&
    ([MaxDate]-Table[LT_opened_at])*1<=30)),ALL(Mastercalendar))
    /[occurrences]+0

bizbi's avatar
bizbi
Advocate I
8 years ago

Occurences_15 = CALCULATE([Occurences]
,FILTER(uvw_GBS_KPIs_HR_v2,[MaxDate]-uvw_GBS_KPIs_HR_v2[opened_at]<=15))/[Occurences]

 

Occurences_15_30 = (CALCULATE([Occurences]
,FILTER(uvw_GBS_KPIs_HR_v2,([MaxDate]-uvw_GBS_KPIs_HR_v2[opened_at])*1>15&&([MaxDate]-uvw_GBS_KPIs_HR_v2[_opened_at])*1<=30))/[Occurences])+0

 

These two red highlights are cancelling each other.

 

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

The error was I needed to clear some other filters from the mastercalendar.
This works:

CALCULATE(CALCULATE([occurrences],
FILTER(Table,([MaxDate]-uvw_GBS_KPIs_HR_v2[opened_at])*1>15&&
([MaxDate]-Table[LT_opened_at])*1<=30)),ALL(Mastercalendar))
/[occurrences]+0