Variance for Workday Last Month
Hey Everyone, I am trying to get an order count variance based on the working day last month. Here is an example of the data I would like to see. Date /Working day /Count /Previous month workday count /difference 08/19/21 14 105 305 -200 07/21/21 14 305 205 100 06/18/21 14 205 Blank() if no data Blank() if no data 08/18/21 13 150 450 -300 07/20/21 13 450 300 150 06/17/21 13 300 Blank() if no data Blank() if no data I have tried so much and just can't seem to get the data to look like this. If you have a measure to grab the last months working day order count that would be amazing if you can share it. Thats the hardest part for me. Thanks!
