Forum Discussion
MTD calcuation not working
My MTD revenue calculation does not seem to be working. It seems to be aggregating months, not just giving me the current month which is what I want. Even if I put a slicer in it, the slicer ...
Greg_Deckler
Community Champion
Community ChampionSample/example data to recreate the problem is always appreciated. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I don't see any ALL or ALLSELECTED functions in your code so that is not the problem. I guess make sure that there is a relationship between your date table and your fact table.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008