To **bleep** With STARTOFYEAR
Seriously though, all joking aside...what in the world???
Anyway, similar to how I recreated all of those Excel functions, my next fun project is unwiding the insanity that is the DAX Time Inte...
You seem about as angry as I am. I can't believe STARTOFYEAR() requires the actual start of the year to be in the column. This is the problem I had trying to calculate the number of days within the year of a start date;
As you can see, my data only has Jan 2nd instead of jan1st. This threw off the days in year calculation by 1 day. This has got to be fixed. To *BLEEP* with STARTOFYEAR()! This is rediculous!