How to set parameters on a measure for the current month and day but in the previous year
Hello Forum, I am having an extremely hard time figuring out how to get the desired results from a measure. Below you see my DAX measure: Cumulative Sales Volume Previous Year = CALCULATE( [Cumulative Sales Volume], SAMEPERIODLASTYEAR(v_Dim_Time[Date]), v_Dim_Time[Date] <= TODAY() ) Although, this measure mostly works, it does not only show the completed days from this year in the previous period...rather the entire month/year in the previous period. I want to do a direct day to day comparison and I cannot figure how to constrain the results.
