Forum Discussion
DAX Help
Hi, I'm new to DAX and would like some suggestions on how to complete the following; Table 1 represents the data as we recieve it from the source. In our efforts to study the data we need to...
Thanks for the help, this is exactly what we were looking for!!
Yes, if you select 2 runs, you could do it like the following:
Change In Attitude =
var firstrun = min('Table 1'[Run])
var secondrun = max('Table 1'[Run]) var run1 = calculate(max('Table 1'[Data]), 'Table 1'[Run] = firstrun) var run2 = calculate(max('Table 1'[Data]), 'Table 1'[Run] = secondrun) return run2 - run1
Thanks for the help, this is exactly what we were looking for!!