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...
Need Help
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!

      • ConstantDele's avatar
        ConstantDele
        Frequent Visitor
        2 years ago