Forum Discussion

norken20's avatar
norken20
Helper I
6 years ago
Solved

Calculate Quarter Sales

Hi All,   I'm tryin?g to calculate the sum per quarter of a sales revenue but I can't figure out the best way to compute it. May I know of the best way how?   I have 2 columns table forexample be...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI norken20,

    Any other categories or fields are you used in calculation? If this is a case, please explain more detail about your data structure.

    How to Get Your Question Answered Quickly 
    If not, you can simply use 'quarter' field right part as filter conditions to calculate.

    Measure =
CALCULATE (
    SUM ( Table[Revenue] ),
    FILTER (
        ALLSELECTED ( Table ),
        RIGHT ( Table[Quarter], 1 ) <= RIGHT ( MAX ( Table[Quarter] ), 1 )
    )
)

    Regards,

    Xiaoxin Sheng

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Drag Quarter to your visual and write this measure

=SUM(Data[Revenue])

Hope this helps.