Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have the following three measures:
I've Created the chart below by graphing the MM Revenue YoY Chang:
My questoin =>
2018 Qtr. 1 bar is calculating the entire revenue for 2017 Qtr.1 when running the MM Total Revenue Last Year Calc measure.
I would like this last bar to show the YoY as of Today's date. As an Ex if today is Jan 21st, I would like this chart to show the following calculation:
[ (2018 Revenue from Jan 1st to Jan 21st) - ( 2017 Revenue from Jan 1st to Jan 21st) ] / ( 2017 Revenue from Jan 1st to Jan 21st)
Thank you,
Roham
Solved! Go to Solution.
Hi,
Try this
=CALENDAR(MIN('Order Line'[Created Date]),MAX('Order Line'[Created Date]))
MM Total Revenue All Time = SUM('Order Line'[Total Revenue])
MM Total Revenue Last Year Calc = CALCULATE([MM Total Revenue All Time],SAMEPERIODLASTYEAR(Calendar[Date]))
MM Revenue YoY Change = DIVIDE( [MM Total Revenue All Time] - [MM Total Revenue Last Year Calc] , [MM Total Revenue Last Year Calc])
Hope this helps.
@Ashish_Mathur thanks for posting these formulas. They worked really well for me as well 🙂
You are welcome.
Hi,
Try this
=CALENDAR(MIN('Order Line'[Created Date]),MAX('Order Line'[Created Date]))
MM Total Revenue All Time = SUM('Order Line'[Total Revenue])
MM Total Revenue Last Year Calc = CALCULATE([MM Total Revenue All Time],SAMEPERIODLASTYEAR(Calendar[Date]))
MM Revenue YoY Change = DIVIDE( [MM Total Revenue All Time] - [MM Total Revenue Last Year Calc] , [MM Total Revenue Last Year Calc])
Hope this helps.
User | Count |
---|---|
141 | |
70 | |
70 | |
53 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |