LearnMeExcel
Well-known Member
- Joined
- Aug 11, 2009
- Messages
- 746
- Office Version
- 365
- 2021
- Platform
- Windows
hi
i have new question
i have report with years
like this
https://drive.google.com/open?id=0B-owRCisBn8gSTRTSW8xaTR3blE&authuser=0
what is best measure
i try this on
the result only for year and full year sumation
thank you
i have new question
i have report with years
like this
https://drive.google.com/open?id=0B-owRCisBn8gSTRTSW8xaTR3blE&authuser=0
what is best measure
i try this on
Code:
=CALCULATE([Total Qty],
DATESBETWEEN(Calendar[Date],
STARTOFMONTH(PARALLELPERIOD(Calendar[Date],-12,month)), ENDOFMONTH(PARALLELPERIOD(Calendar[Date],-12,month))))
thank you
Last edited: