Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Previous Year YTD

Hello All,   I need to calculate sum of Actual values. I have column "Actual". I am using two cards to show the sum of Actual. Actual card displaying sum for the curren fiscal year. say From nov202...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Try to change the ""12/31" to "10/31" in your scenario, which defines the year-end date.

     

    Reference: DATESYTD function (DAX) - DAX | Microsoft Docs

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks amitchandak ,

I tried with above dax but not getting correct solution

 

See values using 1st DAX . I think its calculating sum from nov-2019 till feb 2020. I need till october2020

 

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Try to change the ""12/31" to "10/31" in your scenario, which defines the year-end date.

 

Reference: DATESYTD function (DAX) - DAX | Microsoft Docs

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.