"Dynamic" growth not calculating correctly on DAY

[DanS446]

I made a measure to calculate growth compared to last year, it changes what calculates based on the graph displayed data (month, week, day) using "ISFILTERED". It calculates fine for month and week, but for DAY its showing and incorrect value. What could be the problem? Its the same formula in all cases using different date field to calculate.

[DanS446]

I "kind" of solved it, i had to add Month filter for both "current" and "last year" variables. Before returning a value, it compares if "last year value" is 0 or blank since there is no data in that year, meaning the difference will give equal to "current" value, so it returns Blank. But sometimes on DAY level there are values for days with no data on last year. It works fine on Month and Week level, i even made one similar to compare to previous Month instead.

[MFelix]

Hi @DanS446 ,

Instead of doing this complex calculation have you tried using the DATEADD or SAMEPERIODLASTYEAR syntax?

[DanS446]

you cant work with columns row by row on measures right? thats why that measure tries to filter everything it needs and gets average of the % value for that section of data.

Can you suggest an example of code with DATEADD? (same...lastyear would only work for a single case).