How to calculate MTD and YTD error ratio

[SabG2K]

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 · Accepted solution]

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