Forum Discussion

BrianNeedsHelp's avatar
BrianNeedsHelp
Resolver I
1 year ago
Solved

Calculation Enigma

I compute this year's daily goals based on last year/same month.  I get previous year like this- 364 days previous is the same weekday so it aligns properly.   PYGA1=CALCULATE( 'Subscriber Activity...
  • BrianNeedsHelp's avatar
    BrianNeedsHelp
    1 year ago

    Tried parallel period but it put and astronomical number in each row. But I finally got the PYGA1 column to add up correctly by inputting another measure:  

    SUMX(SUMMARIZE(MyCalendar,MyCalendar[Date]),CALCULATE(SUMX(MyCalendar,[PYGA1])))
BrianNeedsHelp's avatar
BrianNeedsHelp
Resolver I
1 year ago

Tried parallel period but it put and astronomical number in each row. But I finally got the PYGA1 column to add up correctly by inputting another measure:  

SUMX(SUMMARIZE(MyCalendar,MyCalendar[Date]),CALCULATE(SUMX(MyCalendar,[PYGA1])))
v-aatheeque's avatar
v-aatheeque
Community Support
1 year ago

Hi BrianNeedsHelp ,

Thanks for the update, and well done on resolving the issue with the SUMX(SUMMARIZE(...)) approach and effective way to ensure the daily values aggregate correctly, especially when adjusting for edge cases like end-of-month alignment.

 

If everything looks good on your end now, we’d appreciate it if you could mark your solution as Accepted. This helps other users who may face similar challenges find guidance more easily.

Feel free to reach out if you need further assistance or want to explore additional improvements we are happy to help!!