Forum Discussion

amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

Dax date help

Our fiscal year is July 1st - June 30th.    We currently have 2023 data for July - January.   I am trying to comparing last years 2022 data for July - January.   The formula below gives me wh...
amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

basically

VarStart Date = Start of last fiscal year

end date  = lastest date available in data table 

any help is apprecaietd!

 

andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

Can you please post a data example for borh tables: How you define start last fiscal year? 

  • amandabus21's avatar
    amandabus21
    Icon for Helper V rankHelper V
    3 years ago

    We are currently in Fiscal Year 2023. So Calenadr Dates:  July 2022 - June 2023. 

     

    Last 2022 fiscal year would be: Calendar dates : July 2021 - June 2022

     

    We have data for 2023 fiscal year and want to compare it to how we were doing this time last year.