I have a table with some values that I want to compare across rows (specifically, I want to tell the percent difference between them by Month). Here is a sample table with what I'm talking about.
I want to compute the % difference between the Count of Value1 in Month 1/1/2021 with the Count of Value2 in the same month, but as a novice with DAX, I'm not sure how I can set up a filter that ensures the values I'm pulling are from the same month. This is where I'm starting from:
Thank you for the hint. I was able to make it work using the basic pattern you shared. I benefitted from the fact that Value1 would always be the highest value so I didn't need to consider it in the formula.
My final result in case anyone else may benefit from it.
VAR __current = [Count]
VAR __prevDate = MAXX(FILTER('Table', [Date] <= EARLIER([Date])), [Date])
VAR __denominator = MAXX(FILTER('Table', [Date] = __prevDate), [Count])