Forum Discussion

omariobross's avatar
omariobross
New Member
5 years ago

HELP - Average over QoQ% quick measure

Hi all! 🙂   I've just calculated, using a quick measure method, a Quarter over Quarter percentage change. If it's true that I got the desire result as is showing on the following table , I'd like ...
average of a measure
Help Requested
Quarter over Quarter
omariobross's avatar
omariobross
New Member
5 years ago

Hi amitchandak , thanks a lot!

 

Only an additional question please:
What should I consider additionally if I want the diff% that consolidate all the quarters for one year, and not the last one?

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

omariobross , I think you taking about subtotal. At year level it might use only last qtr

 

Create YTD diff in same manner

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date])))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,QUARTER)))

 

use isinscope to switch the measure

 

if(isinscope(Date[Year]) && not(isinscope(Date[Qtr])) , [YTD Diff%], [QTD diff%])

 

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/