Forum Discussion

luisabsg's avatar
luisabsg
New Member
4 years ago

Average power bi

Hi, how are you?

I would like to know if it is possible to average CasesID per month, for example:

 

There is a column called CaseID and with the months 

 

I wanted that doing the average of CasesID per Month to create a tendence graphic like this below. Have how doing this?

 

 

 

 

Need Help
Show and Tell

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    luisabsg , Try a measure like

    averageX(Table, Table[Year], Table[Mes], "_1", count(Table[ID]))

     

    or

    averageX(Table, Table[Date], "_1", count(Table[ID]))

    • luisabsg's avatar
      luisabsg
      New Member
      4 years ago

      Which table I have to add in averageX(Table) ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi luisabsg ,

        If all these columns are in the same table, you don't have to create any measure or calculated column. Drag the CountID field directly to the Feilds area and add the aggregation function (Discount) as shown below.

        If the above one is can't help you get the expected result, please provide some sample table in table Page 1with Text format and your expected result with calculation logic and special examples. Thank you.

        Best Regards