Forum Discussion
Identifying Status Change Between 2 Date Selections
- 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
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
Hi asa70 ,
Thanks for your response,
If you have found the resolution, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Chaithra E