Forum Discussion

grega's avatar
grega
Helper II
2 years ago
Solved

Current FY vs Previous FY

Hi,   I'm struggling with a measure that I need to create.   Our financial period runs from 01/09 to 31/08   I need to report the Current FY.  For that, I'm using a Fiscal CurrYearOffset Date t...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi grega - can you try the below measure as per FYCY

    Current FYTD Sales =
    CALCULATE(
    [Total Sales],
    DATESYTD(
    'Date'[Date],
    "08/31"
    )
    )

     

    Create another measure for FYPY

    Previous FYTD Sales =
    CALCULATE(
    [Total Sales],
    DATESYTD(
    SAMEPERIODLASTYEAR('Date'[Date]),
    "08/31"
    )
    )

     

    Try the above logic , let know

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

     

     

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi grega - can you try the below measure as per FYCY

Current FYTD Sales =
CALCULATE(
[Total Sales],
DATESYTD(
'Date'[Date],
"08/31"
)
)

 

Create another measure for FYPY

Previous FYTD Sales =
CALCULATE(
[Total Sales],
DATESYTD(
SAMEPERIODLASTYEAR('Date'[Date]),
"08/31"
)
)

 

Try the above logic , let know

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

 

 

grega's avatar
grega
Helper II
2 years ago

Hi,  Thanks for the response.  no data is being returned when using the measure. 

  • grega's avatar
    grega
    Helper II
    2 years ago

    It looks like this is an issue with the Date Table I'm using.