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
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

     

    • SaranKumarM's avatar
      SaranKumarM
      Frequent Visitor
      2 years ago

      Hi ConstantDele 

      please give the table name and column in it like below

      Year(Table Name[Date Column name]) 

      It will work.

       

      Thanks,

      • ConstantDele's avatar
        ConstantDele
        Frequent Visitor
        2 years ago

        2023(FRANCEINVOICESResults[Date]