Forum Discussion
PowerBI Expressions
dhara3010 - Sure, you can use the time "intelligence" functions to do these sorts of things like TOTALMTD or TOTALYTD or you can do it with simple filters. With time "intelligence" functions you will need a separate date table.
The general time "intelligence" way looks something like this:
Measure YTD = CALCULATE(SUM([Column]),TOTALYTD('Calendar'[Date]))
A non-time "intelligence" way will look like this:
Measure YTD = SUMX(FILTER('Table',[Date] <= TODAY() && [Date]>=DATE(YEAR(TODAY()),1,1)),[Column])
You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, 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
Finally, please post sample source data. Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, 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
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.