Forum Discussion

thx1137's avatar
thx1137
Helper I
2 years ago
Solved

YTD Quarterly Contribution

Good day,   Need to come up with a calculation for a YTD Quarterly Sales Contribution by Quarter.   I've accomplished the Quarterly Sales Contribution by Quarter by creating a calculated table, a...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, thx1137 

    Based on your information, I create a sample table:

    Then create a new measure and try the following DAX expression:

    YTD_Quarterly_Contribution = 
CALCULATE(
    SUMX(
        FILTER(
            ALL('Table'),
            'Table'[Date] <= MAX('Table'[Date])
        ),
        'Table'[Quarterly Contribution]
    )
)

     

    Here is my preview:

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DataNinja777's avatar
DataNinja777
Super User
2 years ago

Hi thx1137 ,

This may not be the reason of your formula not working, but your formula above is missing square brackets for Revenue measure which I usually expect to see.  

Best regards,