Forum Discussion
NilR
Post Patron
Post PatronSummarize for SAMEPERIODLASTYEAR() not working
I am summing CY to SPLY Data , but data disapears! NUM=
Var _Union=
GROUPBY(
UNION(
SUMMARIZE('TBL',[GP],[ID],[DATE], "@CTCS",CALCULATE(SUMX('TBL',[MBR_CTCS]),SAMEPERIODLASTYEAR('Cale...
Hi NilR ,
Here are the steps you can follow：
1. Create measure.
Measure = IF( YEAR(MAX('Table'[DATE]))=YEAR(TODAY()), SUMX( FILTER(ALL('Table'), 'Table'[ID]=MAX('Table'[ID])&& YEAR('Table'[DATE])=YEAR(MAX('Table'[DATE]))-1&& MONTH('Table'[DATE])=MONTH(MAX('Table'[DATE]))),[MBR_CTCS]) + MAX('Table'[MBR_CTCS]),BLANK())2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
NilRPost Patron
Post PatronThanks for helping:
| GP | ID | DATE | MBR_CTCS |
| 360 | 0072 | 01/01/2022 | 1 |
| 360 | 0072 | 02/01/2022 | 1 |
| 360 | 0072 | 03/01/2022 | 0 |
| 360 | 0072 | 04/01/2022 | 1 |
| 360 | 0072 | 05/01/2022 | 1 |
| 360 | 0072 | 06/01/2022 | 1 |
| 360 | 0072 | 07/01/2022 | 1 |
| 360 | 0072 | 08/01/2022 | 1 |
| 360 | 0072 | 09/01/2022 | 1 |
| 360 | 0072 | 10/01/2022 | 1 |
| 360 | 0072 | 11/01/2022 | 1 |
| 360 | 0072 | 12/01/2022 | 1 |
| 360 | 0072 | 01/01/2023 | 1 |
| 360 | 0072 | 02/01/2023 | 1 |
| 360 | 0072 | 03/01/2023 | 1 |
| 360 | 0072 | 04/01/2023 | 1 |
| 360 | 0072 | 05/01/2023 | 1 |
| 360 | 0106 | 01/01/2022 | 1 |
| 360 | 0106 | 02/01/2022 | 1 |
| 360 | 0106 | 03/01/2022 | 1 |
| 360 | 0106 | 04/01/2022 | 1 |
| 360 | 0106 | 05/01/2022 | 1 |
| 360 | 0106 | 01/01/2023 | 1 |
| 360 | 0106 | 02/01/2023 | 1 |
| 360 | 0106 | 03/01/2023 | 1 |
| 360 | 0106 | 04/01/2023 | 1 |
| 360 | 0106 | 05/01/2023 | 1 |
Ashish_Mathur
Super User
Super UserHi,
I read your original post and have just not been able to understand your requirement. Please explain the question clearly and show the the expected result.
- NilR
Trying to combine the result of Prev year and current Year values per month!