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!!
Thanks for the help!!
Is there a way to make the Run selection a slicer?
We some time have several hundred Runs to compare and creating a Measure for each senario will be quite a challange.
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!!