The ask, take a date value as input and output its calculated day of the year using Power Fx. Not a fancy request, but it is an ask.
- E.g., November 1, 2025, is the 305th day of the year.
Breaking down the final deliverable, its logic creates two collections as data objects in the date picker’s OnSelect action.
For the first collection, it receives the selected value of the date picker control and creates a Sequence() of numbers, one less than the Month() of the SelectedDate.
For the second collection, this builds on a prior ask to calculate the number of days in a month. Reworking that Power Fx, it is condensed into something more succinct, then used to calculate number of DaysInMonth for each month from the first collection:
Note, for a quick visual check, the second collection could be used as a data source for a blank horizontal gallery. This isn’t a part of the final deliverable, but always check your work.
Now, each month of the year and its respective number of days is contained within the second collection. To calculate the day of the year, get the Sum() of the second collection and add the Day() of the date picker’s SelectedDate, and set that as the Text of a label control:
Conclusion:
One formula begets another, which could beget yet another solution. With the logic to calculate the number of days in a month already available, it was repurposed to calculate a date’s day of the year, showing how formulas build on one another.
“You ultimately judge the civility of a society not by how it treats the rich, the powerful, the protected and the highly esteemed, but by how it treats the poor, the disfavored and the disadvantaged.”
Bryan Stevenson
#BlackLivesMatter
console.log('Charles'); 