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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
yugofukuda
Helper IV
Helper IV

Con respecto a TOTALMTD

Hola
Me gustaría calcular el valor cumurative hasta ayer usando todalmtd.
¿Cómo debo cambiar esta expresión en ordar para hacer eso?

TOTALMTD(sum(value),'Calendar'[Date])
2 ACCEPTED SOLUTIONS
camargos88
Community Champion
Community Champion

Hola @yugofukuda ,

Pruebe esta medida:

_T_MTD á TOTALMTD(SUM('Table'[Value]), 'Date'[Date], 'Date'[Date] <- TODAY() - 1)



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

fhill
Resident Rockstar
Resident Rockstar

¿Esto ayuda?

Date_Logic: TOTALMTD(SUM('Table'[Value]), 'Table'[Date], 'Table'[Date] < TODAY())

TotalMTD tiene una opción de FILTRO incorporada...

fhill_0-1598473748269.png




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




View solution in original post

3 REPLIES 3
fhill
Resident Rockstar
Resident Rockstar

¿Esto ayuda?

Date_Logic: TOTALMTD(SUM('Table'[Value]), 'Table'[Date], 'Table'[Date] < TODAY())

TotalMTD tiene una opción de FILTRO incorporada...

fhill_0-1598473748269.png




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




camargos88
Community Champion
Community Champion

Hola @yugofukuda ,

Pruebe esta medida:

_T_MTD á TOTALMTD(SUM('Table'[Value]), 'Date'[Date], 'Date'[Date] <- TODAY() - 1)



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



@camargos88 @fhill
¡¡¡¡Muchas gracias!!!!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.