DTD or Day to date measure

[Cyrilbrd]

Is there a SAMEPERIOD LAST DAY equivalent in DAX?
Hence August 1st to 15th versus July 1st to 15th
Given that today is August 15th.

Given that I have a date DB with dates, day, month, year...

Tried the following but not to avail:

Same Period Last Month = CALCULATE(
[Actual Sales_Pesos],
DATEADD(
Date_DB[Date],-1,MONTH))

I ended up creating a Matrix with the DAY in Rows, MONTH in Columns and sales measure as Values.
I added a slicer for the day and set is as "Between" so I can adjust the period.
Would prefer being able to extract sale values with a formula instead.
Growth rate swould also be computed dynamically.
hence what percentage of growth is August versus July.

This would change monthly, so next month I would have September  vs August.
Any advice?

[VijayP · Accepted solution]

@Cyrilbrd 

Hope you Want this

Use these measures

15 Days back revenue =

IF(DAY(SELECTEDVALUE(Dates[Date]))>15,CALCULATE([Total Revenue],DATEADD(Dates[Date],-15,DAY)),BLANK())

Comparitive Revenue =

IF(ISBLANK([15 Days back revenue]),BLANK(),[Total Revenue])

Hope this helps! if it helps please mention this as Solution and share your Kudos!!

Thanks

Regards

Vijay Perepa

[TomMartens]

Hey @Cyrilbrd ,

I have to admit that I do not fully understand what you are looking for. For this reason, I recommend start reading this article: https://www.daxpatterns.com/time-patterns/#

From my experience, alomost everything time/date related calculations are covered. Also how to consider a leapyear and what to do if today is the 31 of Marth 2020.

Hopefully this provides some ideas on how to tackle your challenge.

Regards,

Tom

[Cyrilbrd]

I edited my question, I am looking for Day to Date. I can do MTD or YTD but am looking for DTD.