Forum Discussion
Quaterly Total
| Date | Open | Close |
| Jan/2019 | 05 | 04 |
| Feb/2019 | 06 | 03 |
| Mar/2019 | 02 | 01 |
| Apr/2019 | 05 | 03 |
| May/2019 | 04 | 04 |
| Jun/2019 | 06 | 02 |
| Jul/2019 | 03 | 01 |
| Aug/2019 | 04 | 02 |
my requiremnt is I want totaly open and close for each quater.
q1 should not add with q2.. I want total of each quater seperatley.
Anonymous
I think you can create a quarter column to get this, However, it will be better if you have a calendar table.
quarter = QUARTER('table'[Date])
3 Replies
- amitchandak
Super User
Anonymous , refer if these can help
https://docs.microsoft.com/en-us/dax/openingbalancequarter-function-dax
https://docs.microsoft.com/en-us/dax/closingbalancequarter-function-dax
nvprasadSolution Sage
Hi,
Establish a relationship with date table and use the Qtr column in the table visual. By default, it will show the respective qtr number.
N
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂Regards,
N V Durga Prasad
ryan_mayuAnonymous
I think you can create a quarter column to get this, However, it will be better if you have a calendar table.
quarter = QUARTER('table'[Date])
