The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |