Solved: Use MTD function without select slicer or filter

it7 · ‎10-04-2019

Hi,

I would like to ask, is it possible to use MTD function without select a slicer and it up to date every month.
Example: If this month Oct it will show Oct data but no need to filter or select a filter.

Bast regards,
it7

amitchandak · ‎10-04-2019

You should try DATESMTD

https://docs.microsoft.com/en-us/dax/datesmtd-function-dax

https://community.powerbi.com/t5/Desktop/Calculating-Month-To-Date-and-Week-to-Date/td-p/67335

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎10-04-2019

You should try DATESMTD

https://docs.microsoft.com/en-us/dax/datesmtd-function-dax

https://community.powerbi.com/t5/Desktop/Calculating-Month-To-Date-and-Week-to-Date/td-p/67335

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Use MTD function without select slicer or filter

Helpful resources

Join us at the Microsoft Fabric Community Conference

Microsoft Fabric Community Conference 2025

A Year in Review - December 2024

How to Get Your Question Answered Quickly

Join us at the 2025 Microsoft Fabric Community Conference