Forum Discussion
YTD and YoY for Measure
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?
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.
2 Replies
- lbendlin
Super User
Power BI has a "Quick Measures" feature which includes examples for the patterns you mentioned. Try them out.
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.
