Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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!
Hi,
thanks but the thing is in the formula, it doesn't give me the opportunity to select my table date
is the Date column is from the same table? could you please send me the screenshot of it ?
Thanks!
please give the table name and column in it like below
Year(Table Name[Date Column name])
It will work.
Thanks,
2023(FRANCEINVOICESResults[Date]
You should not give year here year is the function
please use this "Year_ = Year(FRANCEINVOICESResults[Date])"
Thanks
Thanks, but this what I explained, after I put YEAR, they don't propose me to put "franceinvoices(date)
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
@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!
Proud to be a Super User!
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.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |