Notifications
Clear all
Topic starter
Hi
Is there a DAX formula where you can sum up each quarter and half year.
For example
| Jul | Aug | Sep | Oct | Nov | Dec | Q1 | Q2 | H1 | ||
| Sales | 100 | 200 | 300 | 400 | 500 | 600 | 600 | 1500 | 2100 |
Thanks
Jon
Posted : 24/02/2017 6:07 pm
Hi Jon,
Yes, you can write a DAX formula to do this. This post has some DAX patters for time calculations: http://www.daxpatterns.com/time-patterns/#complete-period-comparison-patterns
I hope that points you in the right direction. Please let us know if you get stuck.
Mynda
Posted : 25/02/2017 7:57 am
Topic starter
Hi Mynda
I will have a read of the article and try to work it out.
As always thanks for your help and I do appreciate it.
Thanks
Jon
Posted : 27/02/2017 5:30 pm
