04-03-2017 11:55 AM
I am looking for the simplest way of creating a measure that just returns day number of the year, ie 2017-04-03 would return 93.
Note: Not trying to create a calculated column.
04-03-2017 12:11 PM
Perhaps something like this:
Measure = (YEARFRAC("Jan 1 2017",TODAY())*360)+1
In lieu of a kudo, consider donating to The Buckeye Ranch
04-03-2017 01:00 PM
Yes, I tried yours first for that reason :-) I will expand on what I am trying to achieve. I have a table with monthly targets.
Jan (20), Feb (25), March (20), April (50), etc
I would like to create a measure that gives me the YTD target per a specific date such as April 5. What is the smartest way of doing that?