cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

PowerBI Expressions

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

1 REPLY 1
Highlighted
Super User IV
Super User IV

@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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors