SUM DATE

[ConstantDele]

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

[SaranKumarM]

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]

Hi,

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

[SaranKumarM]

Hi @ConstantDele 

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

Thanks!

[ConstantDele]

[SaranKumarM]

Hi @ConstantDele 

please give the table name and column in it like below

Year(Table Name[Date Column name]) 

It will work.

Thanks,

[ConstantDele]

2023(FRANCEINVOICESResults[Date]

[SaranKumarM]

Hi @ConstantDele 

You should not give year here year is the function

please use this "Year_ = Year(FRANCEINVOICESResults[Date])"

Thanks

[ConstantDele]

Thanks, but this what I explained, after I put YEAR, they don't propose me to put "franceinvoices(date)

[SaranKumarM]

Hi @ConstantDele 

I guess you are creating Measure please create new Column not meaure.

Thanks,

[ConstantDele]

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

[VijayP]

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

[Anonymous]

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.