Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Hope you Want this
Use these measures
Hope this helps! if it helps please mention this as Solution and share your Kudos!!
Thanks
Regards
Vijay Perepa
Proud to be a Super User!
Hope you Want this
Use these measures
Hope this helps! if it helps please mention this as Solution and share your Kudos!!
Thanks
Regards
Vijay Perepa
Proud to be a Super User!
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
I edited my question, I am looking for Day to Date. I can do MTD or YTD but am looking for DTD.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |