Just wanted to share some useful calculations from this past year and to also see if we can get this group up and running again.
Automated custom fiscal year start - fiscal years are always a pain when if comes to automation. The calc below can help to automate the process. This fiscal year starts in July just substitute the 6 with the int month of your fiscal year start.
Custom FYTD Start:
YEAR(DATEADD('month',-6,[Date])) = YEAR(DATEADD('month',-6,[Date]))
Custom FYTD Volumes this is a two part calculation. Max date finds the max date in the dataset which you reference in the second part of the calculation. Wrapping the second part in an int() converts it to a Boolean where dates that are true return 1 which you can then multiply by your measure value of choice.
- Find your max date : {MAX([Rec Date])}
- Pull in your measure: INT(YEAR( DATEADD('month',-6,[Date])) = YEAR( DATEADD('month',-6,[Date])) AND ([Date]) <= TODAY())* [vol]
Hope these are helpful. I will post more as time allows. Would be great to see this community take off.
Trevor
