Forum Discussion

asa70's avatar
asa70
Advocate I
1 year ago
Solved

Identifying Status Change Between 2 Date Selections

Hi all,   I hope you are all well,   I have a task to showcase mobility of certain individuals between 2 dates. These dates are from 2 date slicers. Basically, when the user selects a start and e...
  • asa70's avatar
    asa70
    1 year ago

    Hi bhanu_gautam , thank you so much for your solution. I did give it a try and it didn't give the correct answer at first. For the startdeptstatus measure, if included in table with all employees, it gave only one value for everything. I added a step to isolate the employees:

    VAR _mindate = calculate(min(table[date]),allselected(table))
    VAR _start = calculate(max(table[status]),
                                      table[date] = _mindate,
                                      table[emp] = max(table[emp]),
                                     allselected(table))
    VAR _end = calculate(max(table[status]),
                                      table[date] = max(table[date]),
                                      table[emp] = max(table[emp]))

    RETURN
    if( _start = _end, "here", "moved")

    Regards,
    Asa