DAX formula

Question

Hello everyone !&nbsp;I have an issue with a DAX formula.&nbsp;I have a table named "Incomind documents". It's one row per ticket (workload), a column with the status (done, on hold, to treat, etc.) and a column with the reception date.&nbsp;I would like to calculate the average of incoming tickets for the last 12 months.&nbsp;Any idea how to do that ?&nbsp;Thanks !

dangar332 · Answer

hi,&nbsp;ElodiePignato&nbsp;&nbsp;&nbsp;result =
 averagex(
     filter('Incomind documents',
        dateadd('Incomind documents'[reception date],-1,year)
            ),
     'Incomind documents[workload]
          )&nbsp;

elodiepignato · Answer

Thank you&nbsp;Dangar332&nbsp;but I have this error message :&nbsp;"The function AVERAGEX cannot work with values of type String.

dangar332 · Answer

hi,&nbsp;ElodiePignato&nbsp;&nbsp;i think your&nbsp; &nbsp;'incomind documents'[workload]&nbsp; is string type. so it could happencan you provide some sample data?

elodiepignato · Answer

I finally used this measure:&nbsp;&nbsp;But it's showing me the exact same result than another formula where I calculate the incoming tickets from last month using "COUNTROWS" :

dangar332 · Answer

HI,&nbsp;ElodiePignato&nbsp;as i understand you want to avg of last 12 month with beginning of month of todayif yes then follow below&nbsp;result =
var a = eomonth(today(),-13)+1   //  this give you  (11/1/2022)  as you want beginning of month of today with 12 month difference

var b = calculate(
          countrows(yourtablename),
          'Incomind documents'[reception date]&gt;=a &amp;&amp;
          'Incomind documents'[reception date]&lt;=today()
                  )  // give rows b/w  (11/1/2022 to 11/2/2022)

return 
divide(b,12))

Forum Discussion

DAX formula - Average

7 Replies

Related content

DAX Formula Help

DAX Formula

Dax Formula correction help

DAX Formula