March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to Solution.
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
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
User | Count |
---|---|
117 | |
77 | |
58 | |
52 | |
46 |
User | Count |
---|---|
171 | |
117 | |
63 | |
57 | |
51 |