Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
cwoo
Regular Visitor

How to calculate fiscal Last year YTD if the Current YTD sales only includes 3 to 4 months

  Financial year ends april 30th 
  last year current year 
  20162017
    
 may900100
 june200200
 jul300300
 aug200100
 sep120100
 oct 200 
 nov 100 
 dec 100 
 jan50 
 feb200 
 mar230 
 apr150 
    
Year to date sept 1720800
    
change   from last year -53.5% 

 

The  problem is calculating  last  year 2016  ( financail  year to date value )   "1720"    since the current  YTD  2017  ends in september  at  800.

 

When  use the  calculate function  and sameperiodlastyear  it  adds up 12 month  of last year not  may - sept  as needed.

 

Can any one help.

 

In short  we are just  trying  to find  our the  ytd  sales of the current year vs the year to date of the last year  "up to the current  sales month  in this case is  september .

 

Can anyone assist.

 

Colin 

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.