Forum Discussion

thx1137's avatar
thx1137
Icon for Helper I rankHelper 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.

Wilson_'s avatar
Wilson_
Icon for Memorable Member rankMemorable Member
2 years ago

Can you please share a sample pbix file? (If you don't know how, please check the pinned thread in the forum.) It would make debugging your issue easier. 🙂