Solved: Valor del mes pasado

treedgf · ‎09-24-2020

Necesito una columna que devuelva el número de "Acessos" del mes anterior para una determinada "Empresa" en un determinado "Município".

Gracias

amitchandak · ‎09-24-2020

@treedgf , Ver una nueva columna como esta puede funcionar

sumx(filter(Table, [Company]-earlier([Company]) && [Municipality]- earlier([Municipality]) && eomonth([date],0) á eomonth(earlier(Date]),-1)),[Accesses])

sumx(filter(Table, [Empresa]-earlier([Empresa]) && [Município]- earlier([Município]) && eomonth([date],0) á eomonth(earlier([Date]),-1)),earlier([Acessos]))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

amitchandak · ‎09-24-2020

@treedgf , Ver una nueva columna como esta puede funcionar

sumx(filter(Table, [Company]-earlier([Company]) && [Municipality]- earlier([Municipality]) && eomonth([date],0) á eomonth(earlier(Date]),-1)),[Accesses])

sumx(filter(Table, [Empresa]-earlier([Empresa]) && [Município]- earlier([Município]) && eomonth([date],0) á eomonth(earlier([Date]),-1)),earlier([Acessos]))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Valor del mes pasado

Helpful resources

Congratulations!

Check out the updates in Power BI.

Microsoft Ignite

The largest Power BI virtual conference