6 years married, yesterday I turned 29 . Still didn't get touched and feelings

Since 6 month ago i started recording the times intamcy took place. Sex has only happened one in a month atimes. Perimenopause was diagnosed less than a six month . So i get the now part but the last 6 month? Thoughts of an affair have been there. No action just thoughts. I'm not happy about the thoughts. I'm not happy about the sexless marriage either. Discussions have been made. The hint at an open marriage was shut down by him very quickly. He makes comments about our lack but when it's time he would not interested in it anymore or just a min sex