Compare current month with previous month in same period

[Anonymous]

Hello, could you help me?
I want to create a measure to bring from the previous month only the quantity up to the same period of the current month. As shown in the image below.
If the most current date you have is October 23rd, I want to create a measure that will bring me the total by September 23rd.

The measure I want to create is the column (TOTAL PREVIOUS MONTH PERIOD (23)) from the example.
I tried with PREVIOUSMONTH and DATEADD, but I was unsuccessful. Always brings the full date of the previous month.

Attached or dataset for example

http://ge.tt/6OiCmKy2

[Anonymous · Accepted solution]

I managed to solve. Below solution I found.

MEDIDA =

VAR LastDate = LASTDATE('DATASET'[DATE])

VAR UltimoDay = DAY(LastDate)

VAR StartLastDate = DATE(YEAR(LastDate);MONTH(LastDate)-1;1)

RETURN

CALCULATE(SUM('DATASET'[QTD]);DATESINPERIOD(CALENDAR[Data];StartLastDate;UltimoDay;DAY))

[amitchandak]

do you continuous dates? The previous month, datemtd etc will work only when you have continuous dates.

Last month MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date Filer],-1,MONTH)))

[Anonymous]

@amitchandak  That way, I also did but he brings the month before full, I need to bring with the same period of days, in this case until the 23rd of both months.

[Tahreem24]

You can calculate the previous month values using below dax formula:
MEASURE = CALCULATE (SUM(SALES), PREVOIUSMONTH(DATE))

Let me know if I am getting your query right.

Please give Kudos and accept this as a solution!

[Anonymous]

@Tahreem24  That way, I also did but he brings the month before full, I need to bring with the same period of days, in this case until the 23rd of both months.