YTD and YoY for Measure

[power_bi_123456]

I'm creating a media dashboard with metrics like CPM, CTR, CPC, etc.

I was asked to add benchmarks to compare. YTD and YoY. How do I calculate that?

[Anonymous · Accepted solution]

Hi @power_bi_123456 ,

You can use the following formulas:

 YTD = TOTALYTD (SUM (Table [Metric]), Date [Date])
 PYTD = CALCULATE ([YTD], SAMEPERIODLASTYEAR (Date [Date]))
 YoY = [YTD] - [PYTD]
 YoY % = DIVIDE ([YoY], [PYTD])

For more information., see:

How to Calculate YTD, MTD, WTD in Power BI (aforanalytic.com)

How to Create YTD Calculations in Power BI​ | phData

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[lbendlin]

Power BI has a "Quick Measures"  feature which includes examples for the patterns you mentioned.  Try them out.