Forum Discussion

tmears's avatar
tmears
Icon for Helper III rankHelper III
9 years ago
Solved

Fiscal Year to Date

Dear all   Any help would be appriciated.  My fiscal Year starts on the 1st of April, i have created the enclosed      I am trying to create a measure which will bring back previous ye...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    tmears

     

    FYTD Measure =
TOTALYTD ( SUM ( Table[Column] ), 'Calendar'[Date], "03/31" )

PFYTD  MEASURE =
CALCULATE ( [FYTD Measure], DATEADD ( 'Calendar'[Date], - 1, YEAR ) )

    Hope this helps! :smileyhappy:

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I am struggling with this.. how do you add the from date as the 1st June each year?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Howdy Jak82 - 

The example provided above  is based on 1st July, if you want to do 1st June, just change the end date to 31/05 like below:

 

 

Booked Sales FYTD = TOTALYTD([Booked Sales],dates[Date], "31/05")