Forum Discussion

NilR's avatar
NilR
Icon for Post Patron rankPost Patron
2 years ago
Solved

Summarize 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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

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's avatar
NilR
Icon for Post Patron rankPost Patron
2 years ago

Trying to combine the result of Prev year and current Year values per month!