IF statment doesn't work!

Beyondforce Just looking at it quickly, it seems that you should just be able to relate the transaction date to the new date table I outline above. I assume the table you are creating is a visual...  It should be really straightforward from there.

The date table will have year and month name

you can create a measure like this: countdate = COUNTA('Date'[Date]) for the days of month

Then it sounds like some straightforward counts on dates or other fields to round out the solution.

If this is over-simplifying, let me know - but the date table will do most of the legwork for the year/month/count of days for sure.