Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I need to calculate MTD,YTD and Inception to date(ITD) on the basis of the CycleID concatination with the date range selected in the slicer(filter). The graph should display Total amount by MTD cycleid wise, Total amount by YTD summation of all cycleid amounts for the particular year selected in the slicer from the start of the year till date and Total amount by ITD summation of all cycleid amounts till date seleted in slicer.
Can anyone help me out on this as soon as possible?
Quick response to this question will be much helpful to me as I need to submit the task today itself.
Thanks & Regards,
Dhara
@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-TIT...
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
2 |