Forum Discussion

ashwani_pal's avatar
ashwani_pal
Helper I
8 years ago
Solved

SUMX Function

Hi,    I am using Sumx Function  to calculate selective data in Power BI report using SUMX as a query in  adding custom column. But It is showing error "Expression.Error: The name 'SUMX' wasn't rec...
Need Help
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi ashwani_pal,

     

    Seems you were using a DAX function in the Query Editor that only accepts Power Query formula language (M language) and R. Please try it out in the Data pane.

    SUMX_Function

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi ashwani_pal,

 

Could you please mark the proper answer as solution?

 

Best Regards!
Dale