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.

Anonymous's avatar
Anonymous
Not applicable
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.