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?