Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Syndicate_Admin
Administrator
Administrator

Mes anterior

Hola, tengo una fórmula DAX que devuelve la suma del último mes. ¿Cómo devolvería la suma del mes anterior?
Último mes
_Headcount Último =
CALCULAR (
suma('HECHO - Plantilla'[Volumen]),
ÚLTIMA FECHA ('HECHO - Plantilla'[Fecha])
)
He probado esto pero no funciona:
_Headcount PM =
CALCULAR (
[_Headcount más reciente],
ANTERIORMES( ( 'DIM - Tabla de fechas'[Fecha] )
))

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

Previous Month Sales = 
CALCULATE(
    [_Headcount Latest],
    DATEADD('Date'[Date], -1, MONTH)
)

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors