Solved: How to calculate MTD and YTD error ratio

SabG2K · ‎05-05-2022

Hello all, I'm attempting to calculate the total number of findings from a certain column and divide it by the total number of enteries from that column to get a MTD and YTD error rate calculation.

amitchandak · ‎05-05-2022

@SabG2K , do you date or year month. If you have date you can get

MTD= CALCULATE([Error Ratio],DATESMTD(('Date'[Date])))

YTD= CALCULATE([Error Ratio],DATESYTD(('Date'[Date])))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎05-05-2022

@SabG2K , do you date or year month. If you have date you can get

MTD= CALCULATE([Error Ratio],DATESMTD(('Date'[Date])))

YTD= CALCULATE([Error Ratio],DATESYTD(('Date'[Date])))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

How to calculate MTD and YTD error ratio

Helpful resources

Join us at the Microsoft Fabric Community Conference

A Year in Review - December 2024

New Offer! Become a Certified Fabric Data Engineer

How to calculate MTD and YTD error ratio

Helpful resources

Join us at the Microsoft Fabric Community Conference

A Year in Review - December 2024