Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic Formula (Measure) that would check whether a value exists in a selected previous period

I am tasked to create a report that will essentially map out the headcount changes from any chosen quarter (ex. Q3 vs Q2, Q2 vs Q1).   I need to separate the headcount walk to: 1) Decrease from em...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Have you considered using INTERSECT() and EXCEPT() for this? Inside your measure you can construct table variables for the affected periods and then use the Venn functions as needed.