Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

FYTD DAX doesn't work

Hi Community, I need help with calculating FYTD sum. Our Financial year runs from July to June. Following is a snapshot of my sample dataset & measures:   FYTD sum should be 360.  FYTD sum...
Need Help
  • SpiroswayGR's avatar
    SpiroswayGR
    5 years ago

    Anonymous 

    FYTD sum = CALCULATE(SUM(Table_name[Sales_field]),Table_name[FYDate]<date(2021,06,31),Table_name[FYDate]>date(2020,07,01))

     

     

    it is working for me well

     

SpiroswayGR's avatar
SpiroswayGR
Resolver III
5 years ago

Anonymous 

FYTD sum = CALCULATE(SUM(Table_name[Sales_field]),Table_name[FYDate]<date(2021,06,31),Table_name[FYDate]>date(2020,07,01))

 

 

it is working for me well