cancel
Showing results for
Did you mean:
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

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

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.

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

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

Proud to be a Super User!

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!