Forum Discussion

Samurai_'s avatar
Samurai_
Regular Visitor
2 years ago

Display Sales by Quarter

Hello,   I'm looking to try to display the total of sales within the last 4 quarters while keeping the same Carrier accross each quarter on the same line throughout the display.  I tried using sma...
ahadkarimi's avatar
ahadkarimi
Icon for Solution Specialist rankSolution Specialist
2 years ago

Hi Samurai_, try these measures below, and if you encounter any issues, let me know.

Last Quarter Sales = 
CALCULATE(
    SUM(Sales[Amount]),
    DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -1, QUARTER)
)

 

2 Quarters Ago Sales = 
CALCULATE(
    SUM(Sales[Amount]),
    DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -2, QUARTER)
)

 

3 Quarters Ago Sales = 
CALCULATE(
    SUM(Sales[Amount]),
    DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -3, QUARTER)
)

 

4 Quarters Ago Sales = 
CALCULATE(
    SUM(Sales[Amount]),
    DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -4, QUARTER)
)

 

Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Supplier!

Samurai_'s avatar
Samurai_
Regular Visitor
2 years ago

I cant put measure data fields into "Small Multiples" section. Is there another way to display this?