Forum Discussion

Mrignalini's avatar
Mrignalini
Frequent Visitor
1 year ago
Solved

LASTDATE Filter issue

I am using below code for calculating a measure which will show the result for the last date selected in the date slicer between filter.  CALCULATE(DISTINCTCOUNT(processor_management[user_id]) ,...
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    hi Mrignalini ,

     

    try like:

    CALCULATE(
        DISTINCTCOUNT(processor_management[user_id]) , 
        processor_management[role]  = "Reviewer", 
        Filter(
            processor_management, 
            processor_management[updated_at - Date] = MAX(processor_management[updated_at - Date])
        )
    )

     

    LASTDATE is a time intelligence function, it has many preconditions.

FreemanZ's avatar
FreemanZ
Super User
1 year ago

hi Mrignalini ,

 

try like:

CALCULATE(
    DISTINCTCOUNT(processor_management[user_id]) , 
    processor_management[role]  = "Reviewer", 
    Filter(
        processor_management, 
        processor_management[updated_at - Date] = MAX(processor_management[updated_at - Date])
    )
)

 

LASTDATE is a time intelligence function, it has many preconditions.