Forum Discussion
rerangel
Helper I
Helper IAVERAGE OF A SUM.....
Hi. i have a table of customer: co_cli fecha tc 0001 2020-01-01 1 0002 2019-06-30 1 003 2020-04-28 0 Where co_cli is the customer id, fecha is the regis...
Solved the problem
Well, go to sql and make a query with the info just how i needed into a new table in power bi.
Thanks
amitchandak
Super User
Super Userrerangel , Seem like you need reverse of this
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
Try Like - averagex(summarize(table,table[año],table[mes],"_1",[NRO CLIENTES ACTIVOS]),[_1])
rerangelHelper I
Helper ISolved the problem
Well, go to sql and make a query with the info just how i needed into a new table in power bi.
Thanks