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
Ashish_Mathur
Super User
Super UserHi,
Share some data, exlplain the question and show the expected result.
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 |