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])))

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

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])))

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!