Thursday 10 March 2016

Table Calculation Functions

1.WINDOW,RUNNING FUNCTIONS:-

WINDOW functions perform aggregations on a selected range of data that is included in the structure of the view. The range is set by negative integers moving backward from a point and positive integers moving forward from a point. The arguments FIRST() and LAST() as well as parameters and other fields can also be used to include all data from a given point to the beginning or end of the data set.





2.LOOKUP:-

LOOKUP looks forward (positive integers) or backward (negative integers) a specified number of dimension values in the view.  Backward and forward can be determined either by the structure of the view (i.e., left to right or top to bottom) or by a specified measure to sort on.





3.INDEX&SIZE:-

INDEX counts 1, 2, 3,… up through however many values there are in a given dimension or combination of dimensions.  
SIZE tells you the number of values in a given dimension or combination of dimension.  You can think of SIZE as the maximum INDEX value.




Thanks Guru's,
Prazval .ks

DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks