Need help with DAX

Question

Hey Everyone,&nbsp;I need your help.I have a table with Recording details by month and I would like to see the difference based on slicer selection.User has to select two Months in a slicer to compare the numbers.Difference = Recordings (Later Month) - Recordings (Earlier month)&nbsp;&nbsp;Table data looks like this:&nbsp;Is there a way to make the measure dynamic so it follows the slicer selection?&nbsp;&nbsp;

greg_deckler · Accepted Answer

Anonymous&nbsp;There is if you unpivot those month columns so that you have:
Month, Value
March, 1200
April, 1500
...
You could then do this:
Difference Measure = 
  VAR __Min = MIN('Table'[Month])
  VAR __Max = MAX('Table'[Month])
  VAR __Month1 = MAXX(FILTER('Table',[Month] = __Min),[Recordings])
  VAR __Month2 = MAXX(FILTER('Table',[Month] = __Max),[Recordings])
RETURN
  __Month2 - __Month1
In reality, you will want a MonthSort column for Sort By and probably have to use that for your max/min, etc.

Forum Discussion

Need help with DAX

2 Replies