MTD & Prev Month MTD Calculations

[Kpower]

I created a column for MTD with

MTD= TOTALMTD(sum(TRANSACTIONS[AMOUNT]), YEAR_MONTH_DIMENSION_TAB[Date]). It shows only if I selected current month in the filter.

How to show the data without selecting the month as a Card in the report??

[parry2k]

here is another topic in the forum related to this, hope it is helpful

http://community.powerbi.com/t5/Desktop/Time-Intelligence-TOTALMTD-vs-DATESMTD-vs-DATEADD/td-p/10088

if not, let me know and will be happy to help.

[Kpower]

MTD NetAmount = CALCULATE(sum(TRANSACTIONS[NET_AMOUNT]), DATESMTD(TRANSACTIONS[DATE_MODIFIED])) when I used the date column from same Fact table I'm getting data without selecting any month in the slicer.

But for Previous MTD Im getting blank on Card. I used

Prev MTD = CALCULATE(sum(TRANSACTIONS[NET_AMOUNT]), PREVIOUSMONTH(TRANSACTIONS[DATE__MODIFIED]))

Can you help me to get previous month data

[parry2k]

I have sample file which I can send to you which calculated prev mtd, qtd, ytd. Send me your email in private message in case you are intereste. Thanks

[FrankPower-001]

Hi, can you send met the file also, please?

frankgovers at outlook.com

[alanhodgson · Accepted solution]

Hey @Kpower,

Try this as a new measure:

Prev MTD = CALCULATE(sum(TRANSACTIONS[NET_AMOUNT]), PREVIOUSMONTH(DATESMTD(TRANSACTIONS[DATE__MODIFIED])))

Results:

[FCF]

hi 

i tried this solution and get this error message, really struggling with MTD and YTD

[Ashish_Mathur]

Hi,

Check the format of the column that you are referring the DATESMTD function.  It is probably a text column.  Change the format to Date.