cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

DTD or Day to date measure

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: DTD or Day to date measure

@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])

2020-08-15_171900.png

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

Thanks

Regards

Vijay Perepa

View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: DTD or Day to date measure

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Highlighted
Helper III
Helper III

Re: DTD or Day to date measure

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

 

Highlighted
Solution Sage
Solution Sage

Re: DTD or Day to date measure

@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])

2020-08-15_171900.png

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

Thanks

Regards

Vijay Perepa

View solution in original post

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors