Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone, I'm having trouble getting the commulive sellings by month on my data. I have tried several options but the calculated field does not add the value of the last month.
Heres ha picture of what I'm trying to achive and the formula used on the calculated field:
I created the calendar table with the dates:
I also triyed this expression with no results either:
Año Acumulado = CALCULATE ( SUM ('Ene-Sep2017'[VALOR]);FILTER(ALL(Calendario[fecha]);Calendario[fecha]<= MAX(Calendario[fecha])))
Thanks for the help in advance, I'm new to power BI and just discovered this DAX world lenguage.
Daniel.
Solved! Go to Solution.
OK, can you please tell me why are you using Calendar table to calculate your total sum but then in your table Month column is from your Ene-Sep 2017 table???
Hope this helps if not send me some sample data and I will help you.
Regards
Abduvali
Hi @DanChaos,
Use this to calculate your running total:
Hope this will solve your issue =D
Regards
Abduvali
Hi @DanChaos,
Try this:
See if that works now =D
Regards
Abduvali
the values are not adding up, shows the same value as the originial:
OK, can you please tell me why are you using Calendar table to calculate your total sum but then in your table Month column is from your Ene-Sep 2017 table???
Hope this helps if not send me some sample data and I will help you.
Regards
Abduvali
It worked, thank you!!.
I used other table following the suggestions in other post about having a diferent table with the dates. In case I wanted to do a cummulative sum by year how does the formula change?.
Great that it worked =D
Regards
Abduvali
Hi again, I just noticed that the sum is not working well, here's the pic:
Could it be the date format?, we use day/month/year; US usually uses month at the start.
I took 2 months of data in this file so you can work with it: data sample
thanks again for the effort.
Daniel
Hi @DanChaos,
Use this to calculate your running total:
Hope this will solve your issue =D
Regards
Abduvali
Thank you, that did the trick!
You are welcome =D
Regards
Abduvali
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |