Forum Discussion
icdns
Post Patron
Post PatronSame period last year using 1 table
Hi everyone, I would like to get the value same period last year using one table. I have my date and measure (value) in my table. I have no date dimension. I have this formula but it is not work...
Hi icdns ,
According to your statement, I think you can try code as below to create a measure.
Previous Year Rainfall = VAR _CURDATE = MAX(RainfallData[Date]) RETURN CALCULATE( SUM(RainfallData[Rainfall]), FILTER( ALLSELECTED(RainfallData), RainfallData[Date] = DATE(YEAR(_CURDATE)-1,MONTH(_CURDATE),DAY(_CURDATE)) ) )Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
littlemojopuppy
Community Champion
Community Championicdns why don't you have a date table? This would be really, really easy if you had a date table and marked it appropriately. Then you could use time intelligence functions and specifically SAMEPERIODLASTYEAR().
icdnsIs it possible if I will not use a date table?