Forum Discussion

ConstantDele's avatar
ConstantDele
Frequent Visitor
2 years ago

SUM DATE

Hi everyone,

 

I'd like to calculate the sum of a specific date .

 

Here is the format : 

I have until May 2024

I would like to have the total of 2024 in a measure, same for 2023, so that after I can make growth %

 

Thank you very much for your help

Best

Need Help

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ConstantDele 

    It will be better to understand if you describe your requirement properly with proper sample data as well as the expected output ypu want.

    Best Regards.

  • VijayP's avatar
    VijayP
    Community Champion
    2 years ago

    ConstantDele  Is that you want sum of the values based on year , OR you want to add  date1 + DAte2. 

    But Adding dates is not having any data meaning!

  • ConstantDele's avatar
    ConstantDele
    Frequent Visitor
    2 years ago

    Hi,

     

    Sorry if i havn't been clear enough.

    I have date in the format dd/mm/yyyy

    I just want to have a formula showing the sum of quantity within 2024 for example

    Same for month also

     

  • SaranKumarM's avatar
    SaranKumarM
    Frequent Visitor
    2 years ago

    Hi @constantDele

     

    1. Create One calculated Column and Split the Year.

      

    2. For clculcting the Qty based on year please use the below Measure.

    3. Final result will look something like this

    Please Accept this as a Solution if it helps you.

     

    Thanks!

    • ConstantDele's avatar
      ConstantDele
      Frequent Visitor
      2 years ago

      Hi,

       

      thanks but the thing is in the formula, it doesn't give me the opportunity to select my table date

       

      • SaranKumarM's avatar
        SaranKumarM
        Frequent Visitor
        2 years ago

        Hi ConstantDele 

        is the Date column is from the same table? could you please send me the screenshot of it ?

         

        Thanks!