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]) , processor_management[role]  = "Reviewer", Filter(processor_management, LASTDATE(processor_management[updated_at - Date])))

 

Date slicer is below: 

 

 the start date - 11/6/2024 

    End date - 11/7/2024

According to the measure, the value should not change if i change the start date keeping the end date same. But the value changes even if i change the start date. 

  • 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.

1 Reply

  • 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.