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])))
Deku's avatar
Deku
Super User
1 year ago

Try using parallelperoid('Calendar'[Calendar Date], -1, year )

v-aatheeque's avatar
v-aatheeque
Community Support
1 year ago

Hi BrianNeedsHelp ,

 

Has your issue been resolved? If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.

If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!

  • 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!!